Sunday, April 4, 2010

Fixing “Could not repair this error” Error

Database corruption is unfortunate for any database administrator. Damage in database mainly occurs due to metadata structure corruption, improper shutdown of system or server, or malicious software like virus. Although most logical corruption in SQL Server database can be surmounted using DBCC CHECKDB repair command, there are some situations wherein the command fails to repair. These situations occur when the database is severely corrupted and beyond the repair limits of DBCC CHECKDB. In such cases, it is advisable to restore database from an updated backup. But if the backup is unavailable or deficient, then the administrator needs to search for a third-party SQL Database Recovery application.

To illustrate above problem, consider a database administrator receives a database corruption error message while trying to access database. However, on trying to repair database using DBCC CHECKDB command, another error message is encountered:

“Could not repair this error.”

This is severity level 10 error message. As the error message states, the in-built repair command is unable to repair the database. After the above error message flashes, the data saved in the database becomes inaccessible. In addition, the same error message is encountered on every attempt to repair database, using different repair parameters.

Cause:

The repair command fails to repair the database because:

There is severe damage in PFS (Page Free Space), GAM (Global Allocation Map), or SGAM (Shared Global Allocation Page) pages.
Database corruption requires rebuilding of clustered indexes for all or few system tables.

Resolution:

To surmount the above error message and to access the database records, you will need to:

Restore the database from an updated backup.
In case of no backup availability, you need to opt for a commercial SQL Database Repair product.

Such SQL Recovery applications use advanced scanning and repairing techniques to repair any logically corrupted database. These tools can be installed from the Internet and do not require any technical knowledge to perform repair process. Such repair utilities do not make even a single change in the original database.

SQL Recovery comprehensively repairs and restores all SQL Server databases, irrespective of their cause of damage. The SQL Repair utility supports repair of MS SQL Server 2008, 20005, and 2000 databases. It is compatible with Windows 7, Vista, 2008, XP, 2003, and 2000 operating systems.

No comments:

Post a Comment