Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mandrews1234
Starting Member
9 Posts |
 Posted - 2009-09-25 : 11:50:27
|
| I am trying to restore a live database from a development database. I am getting the errorMsg 3201, Level 16, State 2, Line 2Cannot open backup device 'C:\bmi_bak'. Device error or device off-line. See the SQL Server error log for more details.Msg 3013, Level 16, State 1, Line 2RESTORE DATABASE is terminating abnormally.Now I know that, that error is when you try to restore a 2005 to a 2000 database. However, both of these databases are 2005. The only thing I have found for a possible reason is the version on my development db isMicrosoft SQL Server 2005 - 9.00.3073.00 (Intel X86) Aug 5 2008 12:31:12 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2) And the version on my live database isMicrosoft SQL Server 2005 - 9.00.2047.00 (Intel X86) Apr 14 2006 01:12:25 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2) Does anyone have any suggestions on how I can fix this. Please note that the live database has nothing in it, so I can delete it if need be. I have tried deleting it and creating it looking for an option to change the version but I can't. ThanksMichael AndrewsWeb Developerwww.intellicominc.com |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
mandrews1234
Starting Member
9 Posts |
Posted - 2009-09-28 : 09:40:23
|
| I just restarted Enterprise Manager, ran the exact same code, and it worked fine. Go figure.Michael AndrewsWeb Developerwww.intellicominc.com |
 |
|
|
|
|
|
SQL Restore