I am attempting to assist an associate with a database that sufferred through a server crash. They relied on a provider to do backups and they were not. They were able to obtain a mdf and ldf file from the server but it is no longer recognized as a database file when they try to attach it. The database is about 150mb. I am pretty sure the header file is damaged. Are there any tools available to repair this without being attached to SQL Server? I looked at the file through an editor and in comparing it to functioning databases, the header does look different. I tried doing some manual editing to the file, I was able to eliminate the PageAudit Error but now I am getting:
Server: Msg 5172, Level 16, State 15, Line 1
The header for file 'd:\mssql\db\test4.mdf' is not a valid database file header. The FILE SIZE property is incorrect.
This is the error I was originally getting:
Server: Msg 5172, Level 16, State 15, Line 1
The header for file 'd:\mssql\db\test4.mdf' is not a valid database file header. The PageAudit property is incorrect.
In generally I would like to help him out with a tool that rebuilds file headers, if available. It's for a group that helps kids in trouble, so any help would be appreciated. Thanks
Server: Msg 5172, Level 16, State 15, Line 1
The header for file 'd:\mssql\db\test4.mdf' is not a valid database file header. The FILE SIZE property is incorrect.
This is the error I was originally getting:
Server: Msg 5172, Level 16, State 15, Line 1
The header for file 'd:\mssql\db\test4.mdf' is not a valid database file header. The PageAudit property is incorrect.
In generally I would like to help him out with a tool that rebuilds file headers, if available. It's for a group that helps kids in trouble, so any help would be appreciated. Thanks
