MS SQL Server database user might encounter database corruption issues due to improper system shutdown, metadata structure damage, human mistake, and virus infection. In most situations of database corruption, the database user encounters an error message while trying to mount his/her database. The records saved in the database become inaccessible after any such mount error flashes on the screen. To surpass such error messages and to access the database records, the user can run an inbuilt repair command – DBCC CHECKDB. The command checks the logical and physical integrity of the database and resolves logical corruption to the maximum level. However, there are certain situations where the command fails to resolve logical damage. For such cases, the user needs to opt for an effective third-party SQL Database Repair application.

To explain the above scenario, consider the underneath error message that appears when you try to repair the database using DBCC CHECKDB command:

“Msg 8914, Level 16, State 1, Line 1

Incorrect PFS free space information for page (1:628) in object ID 949578421, index ID 0, partition ID 72057594042253312, alloc unit ID 72057594046644224 (type LOB data). Expected value 0_PCT_FULL, actual value 100_PCT_FULL.

Msg 8914, Level 16, State 1, Line 1

Incorrect PFS free space information for page (1:632) in object ID 949578421, index ID 0, partition ID 72057594042253312, alloc unit ID 72057594046644224 (type LOB data). Expected value 0_PCT_FULL, actual value 100_PCT_FULL.

…....”

Similar 8914 error messages flash, stating corruption in every corrupted PFS page. Since the repair utility fails in this case, the database remains unmountable.

Cause:

The above error message appears when the actual bits set in the PFS (Page Free Space) byte differ from actual free space allocated to the page P_ID. The difference occurs due to logical damage in SQL database.

Resolution:

To overcome logical damage in an easy way, you need to follow the below mentioned steps:

Run DBCC CHECKDB command with a suitable repair clause.

If the error message persists, restore the database from an updated backup.

In case of incomplete database backup or no backup, use a commercial SQL Repair application. The SQL MDF Repair tool is completely non-destructive and does not harm the original file.

SQL Recovery Software comprehensively repair and restore logically damaged databases when DBCC CHECKDB fails to meet your expectations. Compatible with MS SQL Server 2008, 2005, and 2000, the read-only SQL Database Repair tool is designed for Windows 7, Vista, 2008, XP, 2003, and 2000.