Restore database--- help!

Question

Restore database--- help!

yan-160997

Ten Centuries

Points: 1179
More actions
September 18, 2006 at 9:48 am

#114800

My database server's controller failed, so I have to restore the database to another server, I run and sql statement, but got the following error message:
Server: Msg 3201, Level 16, State 2, Line 1
Cannot open backup device 'D:\DATA\MSSQL\BACKUP\imagedb1.bak'. Device error or device off-line. See the SQL Server error log for more details.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Please help
Thank you

Yan

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Sreejith Sreedharan SSCertifiable Points: 5403 More actions · Answer 1

Is yiur backup location correct? Does ur new server have the copy of the backup from the old server at D:\DATA\MSSQL\BACKUP\imagedb1.bak

Thanks

Sreejith

yan-160997 Ten Centuries Points: 1179 More actions · Answer 2

Hi Screejith,

I copied the back up file to the local server, and the path in sql is correct. as below:

Restore database imagedb1

from disk = 'D:\DATA\MSSQL\BACKUP\imagedb1.bak'

with recovery, replace, nounload,

move 'imagedb1_data' to 'd:\imagedb1_data.mdf',

move 'Imagedb1_log' to 'd:\imagedb1_log.ldf'

Thanks

Yan

Sameer Raval Hall of Fame Points: 3214 More actions · Answer 3

Check the following article by MAK, In that he has come up with one UDF that basically includes 3 different way we generally use to check the file status.

http://www.databasejournal.com/features/mssql/article.php/10894_3492046_1

HTH,

Kindest Regards,

Sameer Raval [Sql Server DBA]
Geico Insurance
RavalSameer@hotmail.com

Alan L Fan SSC Rookie Points: 28 More actions · Answer 4

Alan L Fan

SSC Rookie

Points: 28

September 19, 2006 at 8:12 am

#661277

Try RESTORE WITH MOVE option

Alan Fan

yan-160997 Ten Centuries Points: 1179 More actions · Answer 5

Thank you. I tried that.

May be something wrong with the file itself. There was a problem during the transfer over the server.

By the way, we got the new controller, the hardware problem was solved, and the database can be seen now.

However, it is a good time to check the backup file.

Thank you, everyone.

Yan

yan-160997 Ten Centuries Points: 1179 More actions · Answer 6

Hi Sameer Raval,

Thank you for the help, I will look the article. I also believe that something wrong with the file because I had a problem to transfer the file, it was stop first and somehow start again.

Have a nice day.

Yan

Zach Nichter Mr or Mrs. 500 Points: 547 More actions · Answer 7

Just out of curiosity, what does the SQL Server error log tell you about the attempted restore. Also check the Event log for any errors at that time.

It could be possible that your file is corrupt.

You should try RESTORE HEADERONLY FROM... WITH CHECKSUM. That should verify your backup.

please post your error log messages if you have any.

--------------------------
Zach

Odds_And_Ends Blog