My good friend asked me about problem in SQL Server 2005 database. He can't open it cause of pop up error: The header for the file 'Worker5.mdf' is not a valid database file header. I've no idea how to help to him, I'm using SQL Server 2017 and I didn't see such issue.
-
-
You may repair sql database with Graphical Interface or alternative variant might be using one solution from Google
- Right-click “Databases” and click the “Attach” option to open the Attach Databases dialog box.
- Click the “Add” button to open the Locate Database Files dialog box.
- Type in the full name of the .MDF file, including the full device and directory path, as the following example illustrates:
c:\data files\my_data.m df
Click the "OK" button. SQL Server Management Studio loads the database from the .MDF file.
Comment