Redgate Backup failing Randomly
goldmedal
Posts: 19
I have a redgate 6 backup job which runs daily . The job seems to fail randomly with the following message in the error log.
ERRORS AND WARNINGS
15/01/2012 03:32:00: Copied E:\master\FULL_(local)_master_20120115_033154.sqb to \\sqlbackup01\sqldumps\SQLRPT01-RedGate\master\FULL_(local)_master_20120115_033154.sqb.
15/01/2012 03:32:00: Backing up MisData (full database) to:
15/01/2012 03:32:00: E:\MisData\FULL_(local)_MisData_20120115_033200.sqb
15/01/2012 03:32:03: Deleting old backup file: E:\MisData\FULL_(local)_MisData_20120113_033210.sqb
15/01/2012 03:32:11: Deleting old backup file: \\sqlbackup01\sqldumps\SQLRPT01-RedGate\MisData\FULL_(local)_MisData_20120113_033210.sqb
15/01/2012 03:32:11: BACKUP DATABASE [MisData] TO VIRTUAL_DEVICE = 'SQLBACKUP_28A41D28-7302-47F7-9397-1396A465038C', VIRTUAL_DEVICE = 'SQLBACKUP_28A41D28-7302-47F7-9397-1396A465038C01', VIRTUAL_DEVICE = 'SQLBACKUP_28A41D28-7302-47F7-9397-1396A465038C02',
VIRTUAL_DEVICE = 'SQLBACKUP_28A41D28-7302-47F7-9397-1396A465038C03', VIRTUAL_DEVICE = 'SQLBACKUP_28A41D28-7302-47F7-9397-1396A465038C04', VIRTUAL_DEVICE = 'SQLBACKUP_28A41D28-7302-47F7-9397-1396A465038C05', VIRTUAL_DEVICE = 'SQLBACKUP_28A41D28-7302-47F7-9
397-1396A465038C06', VIRTUAL_DEVICE = 'SQLBACKUP_28A41D28-7302-47F7-9397-1396A465038C07', VIRTUAL_DEVICE = 'SQLBACKUP_28A41D28-7302-47F7-9397-1396A465038C08', VIRTUAL_DEVICE = 'SQLBACKUP_28A41D28-7302-47F7-9397-1396A465038C09', VIRTUAL_DEVICE =
'SQLBACKUP_28A41D28-7302-47F7-9397-1396A465038C10', VIRTUAL_DEVICE = 'SQLBACKUP_28A41D28-7302-47F7-9397-1396A465038C11', VIRTUAL_DEVICE = 'SQLBACKUP_28A41D28-7302-47F7-9397-1396A465038C12', VIRTUAL_DEVICE = 'SQLBACKUP_28A41D28-7302-47F7-9397-1396A465038C1
3', VIRTUAL_DEVICE = 'SQLBACKUP_28A41D28-7302-47F7-9397-1396A465038C14' WITH BUFFERCOUNT = 30, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (MisData), 15/01/2012 03:32:00', DESCRIPTION = N'Backup on 15/01/2012 03:32:00 Server: SQLRPT01
Database: MisData', FORMAT
15/01/2012 03:34:14: Thread 0 error:
Process terminated unexpectedly. Error code: -2139684861 (The api was waiting and the timeout interval had elapsed.)
15/01/2012 03:34:14:
15/01/2012 03:34:14: Thread 1 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
15/01/2012 03:34:14:
15/01/2012 03:34:14: Thread 2 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
15/01/2012 03:34:14:
15/01/2012 03:34:14: Thread 3 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
15/01/2012 03:34:14:
15/01/2012 03:34:14: Thread 4 error:
Process terminated unexpectedly. Error code: -2139684861 (The api was waiting and the timeout interval had elapsed.)
15/01/2012 03:34:14:
15/01/2012 03:34:14: Thread 5 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
15/01/2012 03:34:14:
15/01/2012 03:34:14: Thread 6 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
15/01/2012 03:34:14:
15/01/2012 03:34:14: Thread 7 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
15/01/2012 03:34:14:
15/01/2012 03:34:14: Thread 8 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
15/01/2012 03:34:14:
15/01/2012 03:34:14: Thread 9 error:
Process terminated unexpectedly. Error code: -2139684861 (The api was waiting and the timeout interval had elapsed.)
15/01/2012 03:34:14:
15/01/2012 03:34:14: Thread 10 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
15/01/2012 03:34:14:
15/01/2012 03:34:14: Thread 11 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
15/01/2012 03:34:14:
15/01/2012 03:34:14: Thread 12 error:
Process terminated unexpectedly. Error code: -2139684861 (The api was waiting and the timeout interval had elapsed.)
15/01/2012 03:34:14:
15/01/2012 03:34:14: Thread 13 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
15/01/2012 03:34:14:
15/01/2012 03:34:14: Thread 14 error:
Process terminated unexpectedly. Error code: -2139684861 (The api was waiting and the timeout interval had elapsed.)
15/01/2012 03:34:14:
15/01/2012 03:35:26: SQL error 3013: SQL error 3013: BACKUP DATABASE is terminating abnormally.
15/01/2012 03:35:26: SQL error 3271: SQL error 3271: A nonrecoverable I/O error occurred on file "SQLBACKUP_28A41D28-7302-47F7-9397-1396A465038C:" 995(failed to retrieve text for this error. Reason: 15105).
And here is the corresponding windows error log
SQLVDI: Loc=TriggerAbort. Desc=invoked. ErrorCode=(0). Process=2144. Thread=13388. Server. Instance=MSSQLSERVER. VD=Global\SQLBACKUP_28A41D28-7302-47F7-9397-1396A465038C_SQLVDIMemoryName_0.
BackupVirtualDeviceFile::RequestDurableMedia: Flush failure on backup device 'SQLBACKUP_28A41D28-7302-47F7-9397-1396A465038C01'. Operating system error 995(failed to retrieve text for this error. Reason: 15105).
ERRORS AND WARNINGS
15/01/2012 03:32:00: Copied E:\master\FULL_(local)_master_20120115_033154.sqb to \\sqlbackup01\sqldumps\SQLRPT01-RedGate\master\FULL_(local)_master_20120115_033154.sqb.
15/01/2012 03:32:00: Backing up MisData (full database) to:
15/01/2012 03:32:00: E:\MisData\FULL_(local)_MisData_20120115_033200.sqb
15/01/2012 03:32:03: Deleting old backup file: E:\MisData\FULL_(local)_MisData_20120113_033210.sqb
15/01/2012 03:32:11: Deleting old backup file: \\sqlbackup01\sqldumps\SQLRPT01-RedGate\MisData\FULL_(local)_MisData_20120113_033210.sqb
15/01/2012 03:32:11: BACKUP DATABASE [MisData] TO VIRTUAL_DEVICE = 'SQLBACKUP_28A41D28-7302-47F7-9397-1396A465038C', VIRTUAL_DEVICE = 'SQLBACKUP_28A41D28-7302-47F7-9397-1396A465038C01', VIRTUAL_DEVICE = 'SQLBACKUP_28A41D28-7302-47F7-9397-1396A465038C02',
VIRTUAL_DEVICE = 'SQLBACKUP_28A41D28-7302-47F7-9397-1396A465038C03', VIRTUAL_DEVICE = 'SQLBACKUP_28A41D28-7302-47F7-9397-1396A465038C04', VIRTUAL_DEVICE = 'SQLBACKUP_28A41D28-7302-47F7-9397-1396A465038C05', VIRTUAL_DEVICE = 'SQLBACKUP_28A41D28-7302-47F7-9
397-1396A465038C06', VIRTUAL_DEVICE = 'SQLBACKUP_28A41D28-7302-47F7-9397-1396A465038C07', VIRTUAL_DEVICE = 'SQLBACKUP_28A41D28-7302-47F7-9397-1396A465038C08', VIRTUAL_DEVICE = 'SQLBACKUP_28A41D28-7302-47F7-9397-1396A465038C09', VIRTUAL_DEVICE =
'SQLBACKUP_28A41D28-7302-47F7-9397-1396A465038C10', VIRTUAL_DEVICE = 'SQLBACKUP_28A41D28-7302-47F7-9397-1396A465038C11', VIRTUAL_DEVICE = 'SQLBACKUP_28A41D28-7302-47F7-9397-1396A465038C12', VIRTUAL_DEVICE = 'SQLBACKUP_28A41D28-7302-47F7-9397-1396A465038C1
3', VIRTUAL_DEVICE = 'SQLBACKUP_28A41D28-7302-47F7-9397-1396A465038C14' WITH BUFFERCOUNT = 30, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (MisData), 15/01/2012 03:32:00', DESCRIPTION = N'Backup on 15/01/2012 03:32:00 Server: SQLRPT01
Database: MisData', FORMAT
15/01/2012 03:34:14: Thread 0 error:
Process terminated unexpectedly. Error code: -2139684861 (The api was waiting and the timeout interval had elapsed.)
15/01/2012 03:34:14:
15/01/2012 03:34:14: Thread 1 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
15/01/2012 03:34:14:
15/01/2012 03:34:14: Thread 2 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
15/01/2012 03:34:14:
15/01/2012 03:34:14: Thread 3 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
15/01/2012 03:34:14:
15/01/2012 03:34:14: Thread 4 error:
Process terminated unexpectedly. Error code: -2139684861 (The api was waiting and the timeout interval had elapsed.)
15/01/2012 03:34:14:
15/01/2012 03:34:14: Thread 5 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
15/01/2012 03:34:14:
15/01/2012 03:34:14: Thread 6 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
15/01/2012 03:34:14:
15/01/2012 03:34:14: Thread 7 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
15/01/2012 03:34:14:
15/01/2012 03:34:14: Thread 8 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
15/01/2012 03:34:14:
15/01/2012 03:34:14: Thread 9 error:
Process terminated unexpectedly. Error code: -2139684861 (The api was waiting and the timeout interval had elapsed.)
15/01/2012 03:34:14:
15/01/2012 03:34:14: Thread 10 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
15/01/2012 03:34:14:
15/01/2012 03:34:14: Thread 11 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
15/01/2012 03:34:14:
15/01/2012 03:34:14: Thread 12 error:
Process terminated unexpectedly. Error code: -2139684861 (The api was waiting and the timeout interval had elapsed.)
15/01/2012 03:34:14:
15/01/2012 03:34:14: Thread 13 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
15/01/2012 03:34:14:
15/01/2012 03:34:14: Thread 14 error:
Process terminated unexpectedly. Error code: -2139684861 (The api was waiting and the timeout interval had elapsed.)
15/01/2012 03:34:14:
15/01/2012 03:35:26: SQL error 3013: SQL error 3013: BACKUP DATABASE is terminating abnormally.
15/01/2012 03:35:26: SQL error 3271: SQL error 3271: A nonrecoverable I/O error occurred on file "SQLBACKUP_28A41D28-7302-47F7-9397-1396A465038C:" 995(failed to retrieve text for this error. Reason: 15105).
And here is the corresponding windows error log
SQLVDI: Loc=TriggerAbort. Desc=invoked. ErrorCode=(0). Process=2144. Thread=13388. Server. Instance=MSSQLSERVER. VD=Global\SQLBACKUP_28A41D28-7302-47F7-9397-1396A465038C_SQLVDIMemoryName_0.
BackupVirtualDeviceFile::RequestDurableMedia: Flush failure on backup device 'SQLBACKUP_28A41D28-7302-47F7-9397-1396A465038C01'. Operating system error 995(failed to retrieve text for this error. Reason: 15105).
Comments
What exact version of SQL Backup V6 are you using?
Is this server a 64-bit or 32-bit server server? If the server is 64-bit, can you please check the 32-bit and 64-bit versions of the sqlvdi.dll file. Both versions of the file should match?
Many Thanks
Eddie
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com
The sql server 2008 version is running on a windows 2008 64-bit platform.
The versions of sqlvdi.dll files are as followsing:-
sqlvdi.dll (32-bit)
File Version 2009.100.1600.1
Size 129k
sqlvdi.dll (64-bit)
File Version 2009.100.1600.1
Size 163k
You are still using V6.5.0.73. This version of SQL Backup was only available for two to three weeks before a bug was discovered and fixed in V6.5.0.75.
Therefore can you please upgrade to the latest release, V6.5.1.9 at your earliest convenience. SQL Backup V6.5.1.9 can be obtained using this LINK
Many Thanks
Eddie
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com