CHECKDB found 0 allocation errors and 0 Consistency errors in database sql server found 0 allocation errors and 0 Consistency errors in database

Question

A few days ago, I had a consistency error problem with a database.

It has a very strange behavior after the correction of it, when I execute CHECKDB found 0 allocation errors and 0 consistency errors in database, I don’t make mistakes, but the next day I make a mistake:

Msg 8978, Level 16, State 1, Line 1 Table error: Object ID 525764405, index ID 5, Partition ID 72057606300499968, alloc Unit ID 72057606791430144 (type In-Row data). Page (3:333324) is Missing a Reference from Previous page (3:333323). Possible chain linkage problem.

It’s always the same. Otherwise the application is working normally. I’ve seen the HW And I don’t have any kind of disk errors or memory. Have backup but the same includes this mistake a week ago.

Answer 1

I’ve had that mistake too and a lot of headaches.

According to research, the cause of the problem is some disk instability. In my case, we work with several machines in parallel and one of them the disc stopped at dawn, during several routine procedures.

To solve the problem I had to restore a structural backup of the database and copy ALL data from all tables to that new database. I discovered that there was ONE record in a table that was "corrupted". This record cannot be copied. The problem never happened again.

Those days again, but on another base and another server I had the same error. I ran an UPDATE in the "corrupted" PK table for itself, for example:

UPDATE table SET id = id

The mistake stopped happening, but I can’t explain why and what was the cause of the error.