What to do When Index is Corrupted in SQL Server?
- This topic has 2 replies, 3 voices, and was last updated 6 years, 8 months ago by .
-
Posts
-
If the repair option is “Repair with the Data Loss” I suggest you to restore from your backup otherwise you may not be able to know 100% what data is lost? If you allow data loss you may well have Foreign key inconsistencies and all ghastly outcomes also.
Just repeat DBCC CHECKDB (after each repair) to see if there is any other Repair Command Request, and then run that and then repeat the DBCC CHECKDB, until you get a “clean” outcome.
There is a table in MSDB and if that has only rows in it that may suggest falling hardware.
For easily to understand just go through this article it may helps you a lot.
“How do I know If Index is Corrupted in SQL Server?” I have also got solution by this article when I got stucked http://www.sqlmvp.org/how-to-check-if-index-is-corrupted-in-sql-server/.
- You must be logged in to reply to this topic.