restore database [dbname] from disk = '//server_b/e$/backups/[backupfile.bak]'
I receive the following error:
Server: Msg 3201, Level 16, State 2, Line 6
Cannot open backup device '//server_b/e$/backups/[backupfile.bak]'. Device error or device off-line. See the SQL Server error log for more details.
Server: Msg 3013, Level 16, State 1, Line 6
RESTORE DATABASE is terminating abnormally.
1. I have a domain account set up, and the domain account is running SQLAgent on Server_A. This service has been stopped and restarted, and even MSSQLServer service has been stopped and restarted.
2. From Server_A I can UNC successfully to '//server_b/e$/backups/[backupfile.bak]'.
3. When I run master..xp_cmdshell 'dir //server_b/e$/backups/[backupfile.bak]' I get returned "Access is Denied"
What am I missing? Since I can successfully UNC to the directory and file on
Server_B, it seems there is something not set up right on SQL Server. Please
help.
//
Not only did I have to have the domain account running SQLAgent, but I also had to have the domain account running MSSQLServer on Server_A.
quote:
Originally posted by rerichards
I am attempting to restore a database onto "Server_A" from a backup file located on a disk from a different server, "Server_B". My T-SQL is the following:
restore database [dbname] from disk = '//server_b/e$/backups/[backupfile.bak]'
I receive the following error:
Server: Msg 3201, Level 16, State 2, Line 6
Cannot open backup device '//server_b/e$/backups/[backupfile.bak]'. Device error or device off-line. See the SQL Server error log for more details.
Server: Msg 3013, Level 16, State 1, Line 6
RESTORE DATABASE is terminating abnormally.
1. I have a domain account set up, and the domain account is running SQLAgent on Server_A. This service has been stopped and restarted, and even MSSQLServer service has been stopped and restarted.
2. From Server_A I can UNC successfully to '//server_b/e$/backups/[backupfile.bak]'.
3. When I run master..xp_cmdshell 'dir //server_b/e$/backups/[backupfile.bak]' I get returned "Access is Denied"
What am I missing? Since I can successfully UNC to the directory and file on
Server_B, it seems there is something not set up right on SQL Server. Please
help.
==============
Check these
http://support.microsoft.com/default.aspx?scid=kb;en-us;827452
www.winnetmag.com/SQLServer/ Article/ArticleID/14025/SQLServer_14025.html