Click here to Skip to main content
15,883,896 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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.
Posted
Updated 18-Oct-20 20:41pm
v2
Comments
[no name] 28-Aug-19 8:57am    
"Additional messages in the SQL Server error log or system event log may provide more detail."

That, and / or DROP and (re) CREATE the index ... assuming that is the problem.

Run CHKDSK ... could be a "disk sector" problem.

It's "hinting" you have data corruption.

 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900