How to get rid of SQL error 8927?

While working in SQL Server 2000 one may encounter certain error messages due to one or many reasons. Are you getting the SQL error 8927 and an error message like the following?

"Object ID O_ID, index ID I_ID: The ghosted record count (HG_COUNT) in the header does not match the number of ghosted records (G_COUNT) found on page P_ID."

Due to the occurrence of the error, the entire data stored in the SQL database becomes inaccessible and one cannot use SQL Server anymore. The most common reason for the occurrence of the SQL error 8927 is the corruption in the page definitions. Due to the corruption, the record count in header differs from the number of the ghosted records on P_ID page. To fix the error one needs to follow a few simple steps as mentioned below:

  • Check all the hardware components and see if all of them are working properly or not. Run hardware diagnostics and analyze the error logs to to check if the error is indeed caused due to hardware failure. Swap the hardware components to pin point the Faulty hardware device.
  • If there is a clean and updated backup available then you can recover the inaccessible data in the database from there.
  • Run the DBCC CHECKDB command and find the real cause of the error.

However, if the SQL error 8927 is caused due to corruption and if the extent of the corruption is severe then the aforementioned steps would be of no help. In such a situation you need to use an efficient and reliable third party MDF repair utility that can repair the SQL database and also make the entire data stored in it accessible. An efficient MDF repair utility has the ability to recover each and every database object like tables, stored procedures, triggers, views, defaults, collations and much more. Moreover, it is compatible with all the versions of Windows like Windows 7, Windows XP, Vista, Server 2008, Server 2003, and 2000.