By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,286 Members | 1,634 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,286 IT Pros & Developers. It's quick & easy.

Friend's problem database

EdwardLynch
P: 1
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.
Feb 20 '18 #1
Share this Question
Share on Google+
1 Reply


adamgeorge
P: 1
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.mdf
Click the "OK" button. SQL Server Management Studio loads the database from the .MDF file.
Feb 25 '18 #2

Post your reply

Sign in to post your reply or Sign up for a free account.