yourfirstserver.com

Fixing “the Repair Level On The Dbcc Statement…” Error

Tweet

DBCC CHECKDB is a command that is mainly used to check the logical and physical integrity of MS SQL database. The command can be executed with three different parameters repair_allow_data loss, repair_fast, and repair_rebuild to repair an MS SQL database. While the command ensures absolute repair of logically damaged MS SQL database in most cases, there might be certain situations when this command fails to perform complete repair. Such situations occur when the corruption level of database is too high and beyond the limits of the command. However, a valid backup acts as a boon in such scenarios and allows the user to access the database. But if in case the user has not maintained any database backup, then the only way to repair the database is by using an effective third-party MDF Repair software.

To elaborate the above scenario, consider a practical case where your MS SQL database gets corrupted due to metadata structure damage. Now, when you execute the DBCC CHECKDB command (with repair_fast parameter) to repair your database, you encounter the below error message:

“DBCC results for ‘sysindexes’.
The repair level on the DBCC statement caused this repair to be bypassed.
The system cannot self repair this error.
The repair level on the DBCC statement caused this repair to be bypassed.
The repair level on the DBCC statement caused this repair to be bypassed.
The repair level on the DBCC statement caused this repair to be bypassed.
The repair level on the DBCC statement caused this repair to be bypassed.
There are 1953 rows in 127 pages for object ‘sysindexes’.
CHECKDB found 0 allocation errors and 6 consistency errors in table ‘sysindexes’ (object ID 2).
DBCC results for ‘syscolumns’.
There are 10093 rows in 218 pages for object ‘syscolumns’.
DBCC results for ‘systypes’.
There are 32 rows in 1 pages for object ‘systypes’.
DBCC results for ‘syscomments’. “

The database remains in the corrupted state since the DBCC CHECKDB command is unable to repair the database.

Cause:

The database is severely corrupted and might require rebuilding of indexes or de-allocating of all the corrupt pages.

Resolution:

To overcome corruption of your database, the user needs to repair the database by running DBCC CHECKDB command with repair_allow_data loss parameter. While doing so might resolve the error message, it will also result into deletion of data from your database. To avoid any loss of data, you should opt for a commercial MDF File Repair application. Such MDF Recovery tools do not overwrite or modify the original database during the repair process.

SQL Recovery is an efficient, yet fast MDF File Repair tool that repairs databases created in MS SQL Server 2008, 20005, and 2000. The non-destructive tool retrieves almost all objects of SQL database. It supports Windows 7, Vista, 2008, XP, 2003, and 2000 operating systems.