cmd line backup from remote machine fails intermittently
As part of my backup setup, I am initiating the database backup to file from a remote machine, i.e. I have a backup machine that starts a batch file on the remote(database) machine, which fires SqlBackUpc.exe. After the command returns, the backup process continues and writes the backup file to tape. The problem is that sometimes the process failes. When it does I get the following entries in my event log:
BackupVirtualDeviceSet::Initialize: Open failure on backup device 'SQLBACKUP_109414013'. Operating system error 0x80070002(The system cannot find the file specified.).
BACKUP failed to complete the command BACKUP DATABASE [AngelSQL] TO VIRTUAL_DEVICE = 'SQLBACKUP_109414013' WITH BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = '', DESCRIPTION = '', FORMAT
I have not yet noticed a pattern related to it's failure. Any ideas what might be happening and if there is a workaround?