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