We are having an issue with our SQL backups. This is only happening on large databases. I found a thread that talked about one of the errors in the log and I performed the suggestion for Server 2003 found in that forum (http://support.microsoft.com/kb/304101) and the back ups worked until about 2 AM last night. Now it is throwing errors again. The log contents are below:
2/4/2014 7:45:07 AM: Backing up TitanTV_M3 (transaction log) to:
2/4/2014 7:45:07 AM: \\\\Insmonstor\\Backups\\inssql07_tran\\TitanTV_M3\\TitanTV_M3_tlog_20140204074507.sqb
2/4/2014 7:45:08 AM: Deleting old backup file: \\\\Insmonstor\\Backups\\inssql07_tran\\TitanTV_M3\\TitanTV_M3_tlog_20140202074506.sqb
2/4/2014 7:45:08 AM: BACKUP LOG [TitanTV_M3] TO VIRTUAL_DEVICE = 'SQLBACKUP_C7621DD2-2E58-47C2-8710-BAC27CB638F0' WITH BUFFERCOUNT = 6, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (TitanTV_M3), 2/4/2014 7:45:07 AM', DESCRIPTION = N'Backup on 2/4/2014 7:45:07 AM Server: INSSQL07 Database: TitanTV_M3', FORMAT
2/4/2014 7:45:10 AM: Thread 0 error:
Error 620: Error writing to backup file(s).
Process terminated unexpectedly. Error code: -2139684860
2/4/2014 7:45:10 AM: Warning 210: Thread 0 warning:
Warning 210: Error writing to backup file: \\\\Insmonstor\\Backups\\inssql07_tran\\TitanTV_M3\\TitanTV_M3_tlog_20140204074507.sqb
Warning: System error 1450 (Insufficient system resources exist to complete the requested service)
2/4/2014 7:45:10 AM:
SQL error 3013: SQL error 3013: BACKUP LOG is terminating abnormally.
SQL error 3271: SQL error 3271: A nonrecoverable I/O error occurred on file "SQLBACKUP_C7621DD2-2E58-47C2-8710-BAC27CB638F0:" 995(The I/O operation has been aborted because of either a thread exit or an application request.).
SQL error 3202: SQL error 3202: Write on "SQLBACKUP_C7621DD2-2E58-47C2-8710-BAC27CB638F0" failed: 1117(The request could not be performed because of an I/O device error.)