I don't have enough experience with databases

I'm database administrator in IT company. We have many current projects. But I don't have any experience and I hope you would assist me a little. I operate in Microsoft SQL Server 2008 R2. Only yesterday at 3 p.m. I got a message at opening .mdf...The header for the file 'Project1.mdf' is not a valid database file header. I suppose now I have to find any sql database recovery software or guide or trick to handle it. I feel embarassment of this situation.

1 Comment   [ + ] Show comment
  • The best solution would be to restore from a backup if possible. If you don't have a backup, you could always try stopping the db, backing up the mdf and ldf files, restart, delete and recreate the db, then stop SQL and overwrite the files with the old MDF/LDF files. This will lead to a db recovery so you can run CHECKDB. The other option would be to purchase a repair tool to try and repair manually.

    Did this just randomly happen? Power loss or move to a newer version of SQL? - ohiosoundguy 6 years ago

Answers (0)

This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ