Recover SQL server database

Sidney Poisson

11y1.1k

I am using SQL server 2008 R2, my server has crashed and lost all of the data. I managed to recover the mdf file of database but getting below error message:

Error: 5172, Severity: 16, State: 15.

The header for file 'C:\Program Files\Microsoft SQL Server\MSSQL\DATA\mydatabasename.mdf' is not a valid database file header.

Is there any way to resolve this error message?

Thanks in advanced

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mark Willium11y ago
Hi Sidney, the best method to fix any type of SQL database corruption is Backup. If you have backup of the database then it is the best time to use it.

If backup is not available then try to get help from Paul Randal blog: http://www.sqlskills.com/blogs/paul/search-engine-qa-21-file-header-pages-and-file-header-corruption/

You can also get help from Stellar Phoenix SQL database repair software, as it repairs corrupt SQL server database and restore database objects: tables, triggers, indexes, stored procedures, keys etc.
Upendra Pratap Shahi11y ago
https://social.msdn.microsoft.com/forums/sqlserver/en-US/be7db99a-5e3f-414d-a9e0-d45f99d2928b/corruption-mdf-header-corrupted

http://www.sqlservercentral.com/Forums/Topic443353-266-1.aspx