DataSoftSystem Articles: How to recover corrupted SQL Server 2008 database from Error 8974

Are you using SQL Server 2008 in your organization to carry out enterprise solutions? If yes, then are you experiencing problems in using the database on a regular basis? If this is so, then there are chances that the database may have corrupted because of various reasons. Such reasons could be virus infections, power outages, abrupt system shutdown when the database is open, hardware malfunctioning, etc. In such cases, you should use appropriate corrective measures to repair SQL database. If you are not able to provide any solution, then you should use a third-party MS SQL repair software to do the needful.

Consider a scenario wherein you get the following error message while working on an SQL Server 2008 database:

"Table error: Object ID O_ID, index ID I_ID, partition ID PN_ID, alloc unit ID A_ID (type TYPE). The off-row data node at page P_ID1, slot S_ID1, text ID TEXT_ID is pointed to by page P_ID2, slot S_ID2 and by page P_ID3, slot P_ID3."

Cause:

The root cause of this erroneous situation is that two index records have listed an off-row node as their child node whereas any node can have only one parent node.

Resolution:

To resolve this problem, you should repair SQL database by performing any of the following methods, preferably in the given order:

Check for hardware-related problems: You should check the error logs to find out whether the problem has occurred because of any malfunctioning hardware component. In addition, you can swap the hardware components to isolate the actual cause of error. Lastly, you can also consider to format the hard disks and reinstall the operating system.

Restore from backup: If the problem is not hardware related, then you should restore the database with its clean and updated backup.

Run DBCC CHECKDB: If the backup is not updated, then you should run the DBCC CHECKDB command without any repair clause to determine the corruption level. Then, run it again with the recommended repair clause. This command will delete the off-row data node from P_ID1 and, also, its references from P_ID2 and P_ID3.

After performing these methods, you would not get the similar error. However, if you still find yourself in a similar situation, then you should use a third-party MS SQL repair software to fix the error. Such MDF database repair tools are read-only in nature that do not overwrite the existing database during scanning.

Stellar Phoenix SQL Database Recovery is an SQL Server repair software that repairs SQL databases created in MS SQL Server 7.0, 2000, 2005, and 2008. It is able to recover various database components such as tables, NDF files, stored procedures, queries, triggers, defaults, etc. In addition, this SQL database repair software preserves the relationships among the database tables. It is compatible with Windows 7, Vista, Server 2003, XP, and 2000.