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...
Cannot open backup device '\10.98.76.6\Backups'. Operating system error 1326(failed to retrieve text for this error. Reason: 15105).