MS SQL database corruption can result in serious damages, one of them being complete inaccessibility of all the records saved in database. To surpass any such corruption situation, a user can run DBCC CHECKDB command with a suitable repair clause. This command repairs the database in most situations by resolving all the physical and logical integrity issues. However, if the repair command displays an error message during repair, then it means that the database is beyond the repairing capabilities of DBCC CHECKDB command. In such cases, a database user can restore the database from an up-to-date backup and continue with his/her work. However, if the user has not maintained any database backup, then s/he needs to repair the database using a commercial MDF Database Recovery application.

Consider a practical case, where you encounter the below error message when you try to repair your corrupted MS SQL Server database using DBCC CHECKDB command:

"Server: Msg 8905, Level 16, State 1, Line 0 Extent (1:6945928) in database ID 8 is marked allocated in the GAM, but no SGAM or IAM has allocated it. Server: Msg 8905, Level 16, State 1, Line 0 Extent (1:6945936) in database ID 8 is marked allocated in the GAM, but no SGAM or IAM has allocated it. Server: Msg 8905, Level 16, State 1, Line 0 Extent (1:6945944) in database ID 8 is marked allocated in the GAM, but no SGAM or IAM has allocated it. . . . ....

and then the following:

Repairing this error requires other errors to be corrected first. Repairing this error requires other errors to be corrected first. Repairing this error requires other errors to be corrected first. Repairing this error requires other errors to be corrected first."

The database remains corrupted after the above error message appears.

Cause:

The root cause for the above error message is severe corruption of SQL Server database.

Resolution:

To repair a logically corrupted database when the DBCC CHECKDB command fails to repair, the user needs to use a third-party mdf database recovery software. MDF Repair tools perform complete repair using advanced scanning methods.

SQL Recovery Software is a superb SQL database repair application that repairs MS SQL Server 2008, 20005, and 2000 databases in just three mouse clicks. The MDF Repair tool can be installed on Windows 7, Vista, 2008, XP, 2003, and 2000 operating systems.