Home / server / Questions / 310527
Accepted
JFB
Asked: 2011-09-13 08:09:14 +0800 CST

Backup SQL Server DB to a remote drive

  • 772

I am trying to backup a SQL Server database to another drive letter located on another network on another domain. The location has already been mapped to Z:\ and corresponds to \\10.98.76.6\Backups\. This is the code I have so far in an SQL Query:

BACKUP DATABASE [LabResultDb] TO  
    DISK = Z'\\LabResultDb_backup_12-09-2011.bak' 
    WITH NOFORMAT, NOINIT,  NAME = Z'LabResultDb-Full Database Backup', 
    SKIP, NOREWIND, NOUNLOAD,  STATS = 10

But I get an error message...

Error msg

Cannot open backup device '\10.98.76.6\Backups'. Operating system error 1326(failed to retrieve text for this error. Reason: 15105).

sql-server-2008 database-backup

4 Answers

  1. Best Answer

    Z'\LabResultDb_backup_12-09-2011.bak' - it's not a valid path anyway.

    BACKUP DATABASE [LabResultDb] TO
    DISK = '\10.98.76.6\Backups\LabResultDb_backup_12-09-2011.bak'

    should work. Make sure SQL Server (SQL Server Agent) started with user account (not 'Local System') which have an access to \10.98.76.6\Backups\ share.

    • 2

  2. The reason for the error is because SQL Server runs under a less-privileged account that doesn't have access to your mapped network.

    • 0

  3. To what @Duenni said. I have a backup script that goes to \\path\location\ and it works just fine. Even so, if you want a drive letter try "N'Z:\" not "Z'\"

    • 0

  4. For these who still come across this type of issue.

    Check if the account your server is running on has not changed the password in the meantime. The server will continue to work untill the next restart, but it will fail to authenticate on remote share.

    • 0