subject: Fixing Dbcc Checkdb 8928 Error Message [print this page] 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
