How to Resolve SQL Error 8928 Easily?

The Page Free Space or the PFS pages are used by Microsoft SQL Server databases to search for free space in any database table. These maintain records of the allocation of every page and the free space that is available on these pages. These pages contain critical information that is used by the SQL Server engine while pages are allocated to any new object. But when the database gets damaged due to any reason, the page cannot be read otherwise the server can read the PFS page anytime. In such a situation different errors are encountered like the SQL error 8928 and an error message like the following:

"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 aforementioned error message appears when the PFS page cannot be read successfully because of the physical or logical damage of the database. In such a situation, you can run the DBCC CHECKDB command and get rid of the SQL error 8928. The error could also be the result of hardware problems. To fix the error you can follow the steps mentioned below:

  • Get rid of any hardware related problems: Check the MS SQL server Error logs and the Windows Application logs to find out if the SQL error 8928 is the result of hardware problems.
  • Run hardware diagnostics and swap the hardware to locate the real cause of the error.
  • Execute the DBCC CHECKDB command with the repair clause.

However, if the error is not fixed with the help of all the aforementioned steps then it means that the database is severely damaged. Use efficient MDF repair software to repair the database and get rid of the SQL error 8928.