Fixing DBCC CHECKDB 8928 Error Message
PFS (Page Free Space) page in Microsoft SQL Server database maintains a record of two things – allocation of every page and free space available on each of those pages. The page is the first page and contains critical information used by SQL Server engine t the time of allocating pages to any new object. While the server can read a PFS page anytime, there are a few situations wherein the page can not be read. Such situations primarily occur when your database is logically or physically damaged. In most of these corruption scenarios, the database becomes unmountable, leading to inaccessibility of saved records. Additionally, the database administrator encounters an error message each time s/he encounters the above situation. To overcome the above scenario and to access the database records, the user needs to run DBCC CHECKDB command or restore the data from an updated backup. However, in case of command failure and no backup available, the user needs to opt for a commercial SQL Repair application.
To elaborate the above case in detail, consider the below error message:
“Server: Msg 8928, Level 16, State 1, Line 1
Object ID 389576426, index ID 0: Page (1:18836) could not be processed. See
other errors for details.
Server: Msg 8944, Level 16, State 1, Line 1
Table error: Object ID 389576426, index ID 0, page (1:18836), row 34. Test
(ColumnOffsets + (int)sizeof (COLOFF) <= (nextRec – pRec)) failed. Values
are 31 and 29.”
The above error message appears after the DBCC CHECKDB command fails to repair the database.
Cause:
The above error message appears when the reading of PFS page fails. This failure occurs when the database is logically or physically damaged.
Resolution:
To repair the database, both in physical and logical corruption, follow the below mentioned steps:
1.In case of physical damage, change the damaged physical component.
2.In case of logical damage, run DBCC CHECKDB with suitable repair clause. However, if logical corruption persists, then use third-party MS SQL Repair tools to perform complete repair. Such SQL Database Repair tools use advanced repair techniques to repair any logically damaged database.
SQL Recovery Software is the finest repair tool used by most of the SQL database users to overcome DBCC CHECKDB failure. This SQL Database Repair utility repairs all the database created in MS SQL Server 2008, 20005, and 2000. The read-only tool performs safe repair and can be installed on Windows 7, Vista, 2008, XP, 2003, and 2000.
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 server recovery, mdf recovery, sql recovery and many more. i am sharing my experience and knowledge with you all. For more details visit: http://www.mdfrecovery.com/
Article Source
