Intermittant Transaction Log Backup Failures

kmadsen@hbham.com

I get intermittant backup failures when trying to backup the transaction logs. the following is the error a typical error in the SQL Errorlog.


BackupVirtualDeviceSet::Initialize: Open failure on backup device 'SQLBACKUP_19203613'. Operating system error 0x80070002(The system cannot find the file specified).

VDI log contains
2005/09/28 00:48:26 pid(1532) tid(2084)
Error on Global\SQLBACKUP_22349341
Error at SVDS::Open: Open(control) Status Code: 2, x2
Explanation: The system cannot find the file specified.



Note: It is backing up to a network share, and the next database's transaction log backup completed successfully to the same share less than 4 seconds later. We run transaction log backups every 20 minutes for 15 database and this only occurs every couple of hours. It does not only happen for the same database.

petey

There is a patch that might solve this issue. Contact support for it.

kmadsen@hbham.com

What version contains this patch?

petey

3.2.0.5

deweigend

We are experiencing this problem as well. Is the SQL Backup download version 3.2.0.5? The readme file only says 3.2.0

kmadsen@hbham.com

When I check for updates I get "The Update Service did not find any updates for your application". How do I update from 3.2.0.1 to 3.2.0.5?

Brian Donahue

Please send us an email at support@red-gate.com. The software is not available for download because it is only intended for users who are having problems and is not an officially-tested release.