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 |
|
kaus
Posting Yak Master
179 Posts |
 Posted - 2008-02-13 : 12:35:46
|
| Hi - I'm trying to restore a backup created from a database maintance plan to an empty database. The backup file is there, but when I run restore in EM I get the following error:Microsoft SQL DMO ODBC SQL State 42000cannot open backup device d:\XXXX (a valid server path)Device error or device offline.check SQL Server Log The log says:Operating System Error - The system cannot find specified file.The file where the backup is located is a valid location on the server. How can I fix this? I had it working for awhile by de-selecting the check database integrity option on the integrity tab.ThanksPete |
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2008-02-15 : 11:38:30
|
| Have you double checked to ensure the correct .bak files are there?Usually when I do a restore similar to what you are doing, I select a backup of database then manually change the "Restore As Database"If this is a database from a different server you have to go through the process of selected the backup device. From the Restore Database window. Select "From Device" -> Click "Select Devices" -> Click "Add" -> The "File Name" Radio button should be checked. -> Click the "..." -> Browse to the location of the file name Double Click on the correct .bak file. -> Click "ok" twice (back to the restore database initial window -> You will have to choose the name of your database, existing or new.Clicking Ok then should create/ restore your data. If that is what you did, I cant possibly imagine why you could browse to the file name, but then it repeats that error message. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-16 : 00:42:02
|
| Tried with restore statement? |
|
|
|
kaus
Posting Yak Master
179 Posts |
Posted - 2008-02-19 : 17:18:56
|
| Thank you both for your help. When I restore from device, rather than the database option it works finePete |
|
|
|
|
|
|
Restore Backup -- Cannot Open Device Error