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_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.

//
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_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
Contributing Editor, Writer & Forums Moderator http://www.SQL-Server-Performance.Com

Visit my Blog at http://dineshasanka.spaces.live.com/
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值