Sunday, August 1, 2010

How to solve page header corruption cases in MS SQL Server 2008 database

You must have experienced cases of database corruption more often than not. When you face database corruption, you are unable to work further on the database. These instances can occur due to any arbitrary reason. Some of the most prominent ones could be unplanned system
shutdown especially when the database is open, page header corruption, virus infections in the database, etc. You can repair SQL database by using few workarounds. However, if nothing works fine then using a third-party SQL repair software is the best option.

For instance, the following error message appears while you are working on an MS SQL Server 2008 database:

“Table error: alloc unit ID A_ID, page P_ID. The test (TEST) failed. The values are VAL1 and VAL2.”


Such problem has happened as a database page, P_ID, has not passed auditing test because of page header corruption. You can refer to the error message where it is clearly shown that the TEST string has failed the test.


In such erroneous situations, you should try to address the issue by performing MDF file repair. For the same purpose, there are the following methods that should be performed, ideally in the exact given order:

Verify the hardware components: You should check the state of the hardware components by the following measures:

Check the SQL Server error logs to verify if there is any hardware related error.

Swap the hardware components to narrow down on the exact hardware error, if any.

Check if the disk controller has enabled write-disk caching. If yes, then take the assistance of the hardware vendor to sort this issue.

Format hard drive and reinstall fresh copy of operating system to get a fresh and clean system.

Reinstate database using backup: If the hardware components are alright, then check the state of the database backup. If it is updated, then replace the database with the backup.

Now, check the database after performing these methods. The problem would not be appearing any more. However, at times the database is so severely damaged that it is not repaired using these methods. In such cases, the use of third-party MDF repair tools is required. These tools repair SQL database without overwriting the actual database thus ensuring safe and secure SQL recovery.

In these situations, the most recommended MDF repair software is Stellar Phoenix SQL Data Recovery that repairs MDF file from any random instance of database corruption. Developed for MDF files in MS SQL Server 7.0, 2000, 2005, and 2008, this MS SQL Server repair utility repairs several database objects such as stored procedures, collations, defaults, triggers, tables, NDF files, etc. In addition, this .MDF repair software is compatible with Windows 7, Server 2008, Vista, Server 2003, XP, and 2000.

Article Source :-

No comments:

Post a Comment