Article 3.6.1E : How to resolve Data saving error in SQL ?

Article 3.6.1E : How to resolve Data saving error in SQL ?

1. If your DB is showing error like arithmetic data over flow & data saving error.
2. It means one of your database has been corrupted.
3. You have to repair your DB.
4. First Run the below query to check error in database.

DBCC checkdb(‘DATABASE_NAME’)

5. If you found any error in DB. Then first take the backup & set DB to single user mode using below query.
ALTER DATABASE DATABASE_NAME SET SINGLE_USER WITH ROLLBACK IMMEDIATE

6. Now run the repair query
DBCC CheckDB (‘DATABASE_NAME’, REPAIR_ALLOW_DATA_LOSS)

7. After execution of above query. Set DB to multi user mode
ALTER DATABASE DATABASE_NAME SET MULTI_USER

8. Now refresh the Database & start the ELNet Service.