What are the challenges you face when working across database platforms? Take the survey
Options

cmd line backup from remote machine fails intermittently

colemancoleman Posts: 23
edited September 14, 2005 9:25AM in SQL Backup Previous Versions
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!

Comments

Sign In or Register to comment.