DBCC CHECKDB Fails Displaying 8914 Error by:Mark Willium
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 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.
About the author
I have completed my Ph.D in computer science and currently doing research on how to recover and repair corrupted database. During my research i found many third party software for several database recovery like sql database repair, mdf recovery, db2 recovery, oracle recovery and many more. i am sharing my experience and knowledge with you all. For more details visit:
http://www.mdfrecovery.com/
Has Your Yahoo Account Become Home to a Cyber Stalker? by:Ed Opperman How Content Management System is Useful by:Alan Smith How Important is the Domain Name? by:John Anthony How To Spot An Online Ticket Scam by:Chris Holgate How to Put a Stop to Cyber Stalking Harassment on Your Gmail Account by:Ed Opperman Traveling With Laptop by:Jeremy Mezzi Free Blogging Software with Wordpress by:Chris Holgate Advantages of Locking Laptop Cases by:Jeremy Mezzi Purchasing Laptop Case Online by:Jeremy Mezzi Choosing The FS-1300D by:Steve White Why Quality Laptop Case is a Must by:Jeremy Mezzi Kyocera Mita Laser Printer Warranty by:Steve White T3 Internet - The Great Internet Network for your Call Center Company by:Van Theodorou