I am working on SQL Server 2005 and suddenly I got this error message:
Msg 9100, Level 23, State 1, Line 1rnPossible Index corruption detected. Run DBCC CHECKDB.
If I run DBCC CHECKDB the loss of data occurs. So please give suggestions to eradicate this error.
In such situation you must restore it from backup
1. Run DBCC CHECKDB, make sure all the tables are having a clustered index (physical order of records)n2. If you need to restore the database, it may be save to restore just the db, if not many files have changed or any extensions has been upgraded since. n