Issue
*.MDF' cannot be opened
I'm trying too attach a database but am getting the following error:
cannot be opened because it is version 661. This server supports version 612 and earlier. A downgrade path is not supported.( using ms sql server 2005 and vs2008 )
so my question is
How to copy out the data from that database ? , i don't want upgrade or downgrade versions.
cannot be opened because it is version 661. This server supports version 612 and earlier. A downgrade path is not supported.( using ms sql server 2005 and vs2008 )
so my question is
How to copy out the data from that database ? , i don't want upgrade or downgrade versions.
In Database
Share this post:
Accepted Answer
1. Log into SQL Server Management Studio.
2. Navigate to the database you wish to restore.
3. Right click > Tasks > Restore > Database.
4. Once on the General tab select "From Device" for the source for restore, then navigate to the .bak file you're restoring to.
5. Ensure the Destination for restore is set to the correct database.
6. Select the Options tab.
7. Check "Overwrite the existing database (WITH REPLACE)"
8. Click OK
9. Apply software for unable to open and crashed sql databases http://www.mdf.openfiletool.com/ MDF Open File Tool
2. Navigate to the database you wish to restore.
3. Right click > Tasks > Restore > Database.
4. Once on the General tab select "From Device" for the source for restore, then navigate to the .bak file you're restoring to.
5. Ensure the Destination for restore is set to the correct database.
6. Select the Options tab.
7. Check "Overwrite the existing database (WITH REPLACE)"
8. Click OK
9. Apply software for unable to open and crashed sql databases http://www.mdf.openfiletool.com/ MDF Open File Tool
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here.
Register Here »