Have a look at a similar problem wherein you are facing the following error message while working on an MS SQL Server 2008 database:
"Database error: PAGE_TYPE page P_ID for database 'NAME' (database ID DB_ID) is invalid. This error cannot be repaired. You must restore from backup."
Cause:
The primary cause of this error message is that either the file header page or the boot page is damaged in the mentioned database.
Resolution:
When confronted by this error, you can execute the following methods to repair SQL database:
Address the hardware corruption issues: You should look for the issues that may have caused the hardware components to get damaged. For this, you can do the following tasks:
- Check the error logs. And remove hardware related issue, if any.
- Run hardware diagnostics. And check and correct if any problem is found.
- Check if write-caching is enabled in your system. If yes, then contact your hardware contact to get this rectified.
- Swap the hardware components to zero down on the actual error.
- Format the hard disks and reinstall the operating system.
Restore from backup: If the hardware components are in perfect condition, then check the state of the database backup. If the backup is clean and complete, then replace the database with the backup.
However, there are instances when the MDF file is not repaired using these methods. Also, you cannot even use the DBCC CHECKDB tool as it is not repairable using this utility. In such circumstances, you should repair MDF file using a professional MDF file repair software. These tools are non-destructive in nature that do not overwrite the existing MDF file.
The best SQL repair software that is most trusted is Stellar Phoenix SQL Data Recovery that enables you to repair SQL database. Developed to repair MDF files created in MS SQL 2008, 2005, 2000, and 7.0, this MS SQL repair software repairs numerous database objects such as tables, collations, NDF files, defaults, triggers, stored procedures, etc. Able to restore the table relationship, this.MDF repair software is compatible with Windows 7, Vista, Server 2003, XP, and 2000.
By Mark Willium
Maybe it's better not to repair but backup in time. There are different utilities, like Handy Backup, Genie Backup which backup MS SQL.
There are many problems on my PC. But I couldn't recover all my damaged sql files. Fortunately only today I have found - .mdf file recovery. It surprised me and worked out my troubles.