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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 RESTORE IN REMOTE SERVER

Author  Topic 

noorultsi
Starting Member

2 Posts

Posted - 2008-01-18 : 04:33:42
Greetings To all,

Can any one help me for restore database from Remote Server Backup.

I have tried the following ways.

Restore database DBname from disk='\\server01\sharename\dirname\x.bak'

i have got error like

Device error or device off-line. See the SQL Server error log for more details.

I have checked pathname and spelling everthing is perfect.

Thanks in advance,
Noorul

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2008-01-18 : 09:58:04
what happens if at the command line (from the server u are trying to restore to) u execute "start \\server01\sharename\dirname\" ?

make sure service account has permission on share as well
Go to Top of Page
   

- Advertisement -