cmd line backup from remote machine fails intermittently
coleman
Posts: 23
hello,
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:
18210 :
BackupVirtualDeviceSet::Initialize: Open failure on backup device 'SQLBACKUP_109414013'. Operating system error 0x80070002(The system cannot find the file specified.).
3041 :
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?
Thank you!
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:
18210 :
BackupVirtualDeviceSet::Initialize: Open failure on backup device 'SQLBACKUP_109414013'. Operating system error 0x80070002(The system cannot find the file specified.).
3041 :
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?
Thank you!
Comments
Can you please send us an email to support@red-gate.com explaining this? We will then reply with the latest build, which should fix the problem.