Monday, April 19, 2010

How to resolve the Error 8948 in MS SQL Server 2000?

MS SQL Server is a Relational Database Management System (RDBMS) that is well designed to conform to the advanced needs of enterprises environment, organizations, and high-end users. It provides various tools to ease the burden of database development, maintenance and administrations. One of them is Page Free Space (PFS). It is a page in the database that searches for free space in the table. It contains a byte-map that holds one byte per page (P_ID), approximately 64 MB, in a PFS. However, sometimes P_ID is assigned to a PFS and you are not able to access the page. In such cases, the database becomes inaccessible and may get corrupt. You should replace the database with updated backup. If the updated backup is not available, then you should use an SQL Database Recovery tool to recover SQL database.

Consider a scenario wherein you encounter an error message when accessing a database table in MS SQL Server. The error message is:
“Database error: Page P_ID1 is marked with the wrong type in PFS page P_ID2. PFS status 0xVAL1 expected 0xVAL2.”

After encountering the aforementioned error message, you are unable to access the table or perform any other operation on it.

The error message may have occurred because the bits are not set correctly in the database table, given the type of page and context in which it is read.

To resolve this issue, you can take the following measures:
Run hardware diagnostics and see if the data corruption is because of hardware failure. Try different hardware configurations to check if it is because of any hardware failure.
Replace the database table with its updated backup.
Run DBCC CHECKDB without a repair clause to find out the effect of the data corruption. DBCC CHECKDB will recommend a repair clause to use. Then, use the recommended repair clause with DBCC CHECKDB. The idea behind using DBCC CHECKDB is to set the PFS byte to the correct free space bits and to set them appropriately.

However, if you are not able to do SQL Recovery using the aforementioned measures then you should use a SQL database recovery tool. These read-only tools are highly interactive and employ complex algorithms to scan the damaged area to recover it.

SQL Recovery software is able to repair all the SQL components such as tables, rules, views, stored procedures, indexes, Defaults, Triggers, etc. In addition, it can successfully repair user defined functions and data types. This sql database recovery tool can repair all the databases created in MS SQL Server 2008, 2005, 2000. It is compatible with Windows 7, Vista, 2003 Server, XP, 2000, and NT.

No comments:

Post a Comment