question

Payel_Nag avatar image
Payel_Nag asked

System table pre-checks: Object ID 3 has chain linkage mismatch error in SQL server

I have a serious issue on my database since last few days. The **total size of the database is 286 GB** and **no of tables are 486**. All tables can be open and can fetch data from each table normally. But no maintenance job can run like **DBCC CHECKDB/ DBCC CHECKTABLE or defragmentation** job when I run any one of them I get this error “**Msg 7987, Level 16, State 1, Line 1 System table pre-checks: Object ID 3 has chain linkage mismatch. (1:8073651)->next = (1:4325929), but (1:4325929)->prev = (1:18658983). Check statement terminated due to unrepairable error. DBCC results for 'ABC'. CHECKDB found 0 allocation errors and 0 consistency errors in database 'ABC**'.” The database is in **VMWARE environment** so no physical drive or hardware are there. So no hardware failure is possible. It’s our live database but same database is in test and dev but they run perfectly fine. Can you please tell me how to solve this problem. If we restore from last good backup then we can lose many data which we can’t effort.
errorcheckdb
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
sp_lock avatar image
sp_lock answered
CheckDB Will not fix this issue. If you're unable to restore the DB to the time it wasn't an issue then I would contact MS Support. They may ask you to review all hardware drivers and firmware version before looking into it. You may wish to contact SQLSkills.com and ask if they could help, for a fee of course. Sorry i can not be more helpful
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.