A DBCC CHECKDB failure error message (severity level 16 or 10) appears when corruption in database is beyond the repair limits of the command. Such severe corruption MS SQL Server database is caused due to metadata structure corruption, hardware damage, application damage, and improper server shutdown. Since, the inbuilt repair command is unable to repair the corrupted database, the database remains unmountable and its records also remain inaccessible. To access the database records in such cases, the user needs to restore the database from an updated backup. However, in case of incomplete database backup, the user can use a third-party MDF Repair utility to repair the database.

To illustrate the above situation in detail, consider the below error message that appears when you run DBCC CHECKDB command to repair corrupted database:

“DBCC results for 'FVD_A'. Msg 2511, Level 16, State 1, Line 1 Table error: Object ID 165575628, Index ID 2. Keys out of order on page (1:12743984), slots 97 and 98. There are 72920059 rows in 2281375 pages for object 'FVD_A'. CHECKDB found 0 allocation errors and 1 consistency errors in table 'FVD_A' (object ID 165575628). DBCC results for 'FVD_CVS322'. Msg 2511, Level 16, State 1, Line 1 Table error: Object ID 181575685, Index ID 2. Keys out of order on page (1:7250519), slots 30 and 31.” After the above DBCC CHECKDB error message appears, the database records become inaccessible.

User Action:

To resolve the above error messages and to overcome DBCC CHECKDB failure, the user needs to follow the below mentioned steps:

Use an updated copy of the MDF file and perform restoration at a safe location. In case no backup is available, or backup file is unable to restore the expected database records, then you will need to use a commercial MDF Repair utility to comprehensively repair your database.

An MDF File Repair application incorporates powerful and secure algorithms to fix logically damaged MDF file. The repair tool is constructed with an easy-to-understand user-interface that allows the user to perform repair easily and quickly.

Stellar Phoenix SQL Recovery repairs corrupt MDF files in a few simple steps. The MDF file recovery tool is qualified to repair any damaged MDF, irrespective of its cause of corruption. Compatible with MS SQL Server 2008, 2005, and 2000, the read-only file repair tool does not change the original file records. It is designed for Windows 7, Vista, 2008, XP, 2003, and 2000.