SQL Server Performance Forum – Threads Archive
Restore: Cannot Open Backup Device
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_be$ackups[backupfile.bak]’ I receive the following error:
Server: Msg 3201, Level 16, State 2, Line 6
Cannot open backup device ‘\server_be$ackups[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_be$ackups[backupfile.bak]’.
3. When I run master..xp_cmdshell ‘dir \server_be$ackups[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.
RESOLUTION:
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_be$ackups[backupfile.bak]’ I receive the following error:
Server: Msg 3201, Level 16, State 2, Line 6
Cannot open backup device ‘\server_be$ackups[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_be$ackups[backupfile.bak]’.
3. When I run master..xp_cmdshell ‘dir \server_be$ackups[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.
restore database [dbname] from disk = ‘\server_be$ackups[backupfile.bak]’ I receive the following error:
Server: Msg 3201, Level 16, State 2, Line 6
Cannot open backup device ‘\server_be$ackups[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_be$ackups[backupfile.bak]’.
3. When I run master..xp_cmdshell ‘dir \server_be$ackups[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
]]>