SQL Server Performance

Restore: Cannot Open Backup Device

Discussion in 'General DBA Questions' started by rerichards, Jul 15, 2005.

  1. rerichards New Member

    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.

  2. rerichards New Member

    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.


  3. dineshasanka Moderator

Share This Page