Posted By: Higgin
A PFS (Page Free Space) page in the databases has allocated one byte per page in the file interval, which is about 64 MB. Every byte in the page contains three status bits that convey the type of the page and its status as to whether it is allocated or not. However, this behavior of the PFS page is sometimes not exhibited when the SQL database gets corrupt. The corruption can happen in various scenarios such as virus infections, database header corruption, malfunctioning in hardware components, etc. You should repair SQL database using appropriate in-built eu server status corrective measures. If you are unable to do so, then a good third-party MS SQL recovery software should be used to repair MDF file.
Consider a situation in which you get the following error message while you are working on an MS SQL Server 2000 database:
Database error: Page P_ID1 is marked with the wrong type in PFS page P_ID2. PFS website status monitoring 0xVAL1 expected 0xVAL2.
The root cause of this problem is database check website around the world corruption because of which the bits in the PFS page are incorrectly set.
To rectify this erroneous situation, you would need to repair MDF file. To do this, the following methods can be tried, preferably, in the given order:
Fix hardware-related corruption reasons: You should check the hardware parts to verify that the error has occurred due to hardware malfunctioning or not. This can be done using the following measures:
Checking the Application logs and SQL Server Error logs to check the reason for the error, if available.
Fixing the errors that appear after running hardware diagnostics.
Swapping the hardware components to isolate the actual error of database corruption.
Installing operating system after formatting the hard disks.
Restore from updated backup: You should restore the database with the backup if it is clean and updated.
Run DBCC CHECKDB: You should run DBCC CHECKDB with the suggested repair clause to repair MDF file.
The problem would be rectified in most of the cases after using these methods. However, if you are still getting the same error then you should repair SQL database with the help of a third-party MDF repair software. These read-only database recovery tools are easy to use that do the repairs and save the changes in a new database at a specified location.
The most effective SQL recovery software software for such situations is Stellar Phoenix SQL Data Recovery, which repairs SQL databases created in MS SQL Server 2008, 2005, 2000, and 7.0. Able to repair various SQL databases objects including tables, collations, triggers, defaults, NDF files, etc, this .MDF file repair software is compatible with Windows 7, Server 2008, Vista, Server 2003, XP, and 2000.