Redgate Backup failing Randomly

goldmedalgoldmedal Posts: 19
edited January 20, 2012 10:29AM in SQL Backup Previous Versions
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).

Comments

  • Eddie DEddie D Posts: 1,807 Rose Gold 5
    Thank you for your post into the forum and sorry that you have encountered a problem.

    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
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
  • The version of SQL Backup we are currently using is 6.5.0.73

    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
  • Eddie DEddie D Posts: 1,807 Rose Gold 5
    Thank you for your reply.

    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
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.