I have database which is in inconsistency mode. Now I want to remove inconsistency from database in sql server.
In dbcc checkdb I found consistency error and found that table.
on that table there was cluster index.
First I disable that cluster index.
Now I am unable to enable cluster index. (it gives error)
What I have tried:
1)
DBCC CHECKDB
2)
ALTER INDEX [my index name] ON [my table name] DISABLE
3)
ALTER INDEX [my index name] ON [my table name] REBUILD;
gives error as following
4)
ALTER DATABASE [databasename] SET SINGLE_USER WITH NO_WAIT
5)
use databasename;
dbcc checktable('myDbTableName', repair_allow_data_loss)
It gives following error.
Msg 824, Level 24, State 2, Line 2
SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x95783eb6; actual: 0x4ccb3a4c). It occurred during a read of page (6:41385153) in database ID 5 at offset 0x00004eef982000 in file 'J:\QASDATA5\QASDATA5.ndf'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.