Hello,
We have been using sql backup now for 2 years. as of last week we have been getting an issue every couple of days where our nighly backup has been failing, here is the data from the log file... any ideas?? thanks
SQL Backup log file 6.4.0.1004
-SQL "BACKUP DATABASE [DB802] TO DISK = 'D:\Backups\DB802\<AUTO>.sqb' WITH ERASEFILES = 3, DISKRETRYINTERVAL = 30, DISKRETRYCOUNT = 10, COMPRESSION = 4, THREADCOUNT = 6, VERIFY "
ERRORS AND WARNINGS
2/23/2011 4:00:01 AM: Backing up DB802 (full database) to:
2/23/2011 4:00:01 AM:
\Backups\DB802\FULL_(local)_DB802_20110223_040001.sqb
2/23/2011 4:00:01 AM: BACKUP DATABASE [DB802] TO VIRTUAL_DEVICE = 'SQLBACKUP_35EFCF8F-FCEB-4366-80D5-7A823AF90409', VIRTUAL_DEVICE = 'SQLBACKUP_35EFCF8F-FCEB-4366-80D5-7A823AF9040901', VIRTUAL_DEVICE = 'SQLBACKUP_35EFCF8F-FCEB-4366-80D5-7A823AF9040902',
VIRTUAL_DEVICE = 'SQLBACKUP_35EFCF8F-FCEB-4366-80D5-7A823AF9040903', VIRTUAL_DEVICE = 'SQLBACKUP_35EFCF8F-FCEB-4366-80D5-7A823AF9040904', VIRTUAL_DEVICE = 'SQLBACKUP_35EFCF8F-FCEB-4366-80D5-7A823AF9040905' WITH BUFFERCOUNT = 30, BLOCKSIZE = 65536,
MAXTRANSFERSIZE = 1048576, NAME = N'Database (DB802), 2/23/2011 4:00:01 AM', DESCRIPTION = N'Backup on 2/23/2011 4:00:01 AM Server: WPED001 Database: DB802', FORMAT
2/23/2011 4:02:01 AM: Thread 0 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
2/23/2011 4:02:01 AM:
2/23/2011 4:02:01 AM: Thread 1 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
2/23/2011 4:02:01 AM:
2/23/2011 4:02:01 AM: Thread 2 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
2/23/2011 4:02:01 AM:
2/23/2011 4:02:01 AM: Thread 3 error:
Process terminated unexpectedly. Error code: -2139684861 (The api was waiting and the timeout interval had elapsed.)
2/23/2011 4:02:01 AM:
2/23/2011 4:02:01 AM: Thread 4 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
2/23/2011 4:02:01 AM:
2/23/2011 4:02:01 AM: Thread 5 error:
Process terminated unexpectedly. Error code: -2139684861 (The api was waiting and the timeout interval had elapsed.)
2/23/2011 4:02:01 AM:
2/23/2011 4:02:24 AM: SQL error 3013: SQL error 3013: BACKUP DATABASE is terminating abnormally.
2/23/2011 4:02:24 AM: SQL error 3271: SQL error 3271: A nonrecoverable I/O error occurred on file "SQLBACKUP_35EFCF8F-FCEB-4366-80D5-7A823AF90409:" 995(The I/O operation has been aborted because of either a thread exit or an application request.).
It looks like the backup kicked off at 4:00:01 AM, but was blocked. Your VDI timeout value was probably set to 2 minutes, which is why SQL Backup returned with a timeout error at 4:02:01 AM. Whatever was blocking the backup cleared up at 4:02:24, but SQL Backup had already aborted the backup process by then.
We have been using sql backup now for 2 years. as of last week we have been getting an issue every couple of days where our nighly backup has been failing, here is the data from the log file... any ideas?? thanks
SQL Backup log file 6.4.0.1004
-SQL "BACKUP DATABASE [DB802] TO DISK = 'D:\Backups\DB802\<AUTO>.sqb' WITH ERASEFILES = 3, DISKRETRYINTERVAL = 30, DISKRETRYCOUNT = 10, COMPRESSION = 4, THREADCOUNT = 6, VERIFY "
ERRORS AND WARNINGS
2/23/2011 4:00:01 AM: Backing up DB802 (full database) to:
2/23/2011 4:00:01 AM:
2/23/2011 4:00:01 AM: BACKUP DATABASE [DB802] TO VIRTUAL_DEVICE = 'SQLBACKUP_35EFCF8F-FCEB-4366-80D5-7A823AF90409', VIRTUAL_DEVICE = 'SQLBACKUP_35EFCF8F-FCEB-4366-80D5-7A823AF9040901', VIRTUAL_DEVICE = 'SQLBACKUP_35EFCF8F-FCEB-4366-80D5-7A823AF9040902',
VIRTUAL_DEVICE = 'SQLBACKUP_35EFCF8F-FCEB-4366-80D5-7A823AF9040903', VIRTUAL_DEVICE = 'SQLBACKUP_35EFCF8F-FCEB-4366-80D5-7A823AF9040904', VIRTUAL_DEVICE = 'SQLBACKUP_35EFCF8F-FCEB-4366-80D5-7A823AF9040905' WITH BUFFERCOUNT = 30, BLOCKSIZE = 65536,
MAXTRANSFERSIZE = 1048576, NAME = N'Database (DB802), 2/23/2011 4:00:01 AM', DESCRIPTION = N'Backup on 2/23/2011 4:00:01 AM Server: WPED001 Database: DB802', FORMAT
2/23/2011 4:02:01 AM: Thread 0 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
2/23/2011 4:02:01 AM:
2/23/2011 4:02:01 AM: Thread 1 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
2/23/2011 4:02:01 AM:
2/23/2011 4:02:01 AM: Thread 2 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
2/23/2011 4:02:01 AM:
2/23/2011 4:02:01 AM: Thread 3 error:
Process terminated unexpectedly. Error code: -2139684861 (The api was waiting and the timeout interval had elapsed.)
2/23/2011 4:02:01 AM:
2/23/2011 4:02:01 AM: Thread 4 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
2/23/2011 4:02:01 AM:
2/23/2011 4:02:01 AM: Thread 5 error:
Process terminated unexpectedly. Error code: -2139684861 (The api was waiting and the timeout interval had elapsed.)
2/23/2011 4:02:01 AM:
2/23/2011 4:02:24 AM: SQL error 3013: SQL error 3013: BACKUP DATABASE is terminating abnormally.
2/23/2011 4:02:24 AM: SQL error 3271: SQL error 3271: A nonrecoverable I/O error occurred on file "SQLBACKUP_35EFCF8F-FCEB-4366-80D5-7A823AF90409:" 995(The I/O operation has been aborted because of either a thread exit or an application request.).