backup failing - Thread 0 error

johnp12

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.).

petey

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.

Were there any database restructuring tasks running around that time, that might have blocked the backup? Or another backup (e.g. trx log backup) of the same database that may have been still running during that time?

Thanks.