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

1

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

It has very strange behavior after it is corrected, when I run CHECKDB found 0 allocation errors and 0 consistency errors in database , it does not show me errors, but on the following day I have an error:

  

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 already saw HW and I do not have any type of disk errors, nor memory. I have backup but the same includes this error a week ago.

    
asked by anonymous 18.04.2017 / 12:16

1 answer

0

I've also had this error and a lot of headache.

As research shows, the cause of the problem is some instability on the disk. In my case, we worked with several machines in parallel and one of them the disk stopped at dawn during several routine procedures.

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

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

UPDATE table SET id = id

The error stopped happening, but I can not explain why and why the error occurred.

    
18.04.2017 / 14:55