SQL Backup failed with exit code 820: SQL error code: 3203
DanielBritten
Posts: 15 Bronze 2
I have a weekly SQL backup job that fails about once a month. Does anyone have any ideas?
3/1/2008 3:05:27 AM: Backing up Freight_2006 (full database) to:
3/1/2008 3:05:27 AM: K:\Backups\Weekly\Freight_2006.sqb
3/1/2008 3:05:27 AM: BACKUP DATABASE [Freight_2006] TO DISK = 'K:\Backups\Weekly\<AUTO>.sqb' WITH NAME = '<AUTO>', DESCRIPTION = '<AUTO>', INIT, VERIFY, MAILTO_ONERROR = 'daniel.britten@prgx.com', COMPRESSION = 1, THREADCOUNT = 3
3/1/2008 4:46:50 AM: Database size : 611.835 GB
3/1/2008 4:46:50 AM: Compressed data size: 172.187 GB
3/1/2008 4:46:50 AM: Compression rate : 71.86%
Processed 329048 pages for database 'Freight_2006', file 'FREIGHT_2006' on file 1.
Processed 31959664 pages for database 'Freight_2006', file 'FREIGHT_2006_DATA1' on file 1.
Processed 23408960 pages for database 'Freight_2006', file 'FREIGHT_2006_DATA2' on file 1.
Processed 23612120 pages for database 'Freight_2006', file 'FREIGHT_2006_IDX' on file 1.
Processed 15896 pages for database 'Freight_2006', file 'FREIGHT_2006_INDEX1' on file 1.
Processed 15944 pages for database 'Freight_2006', file 'FREIGHT_2006_INDEX2' on file 1.
Processed 8 pages for database 'Freight_2006', file 'FREIGHT_2006_Log' on file 1.
BACKUP DATABASE successfully processed 79341640 pages in 6071.381 seconds (107.054 MB/sec).
3/1/2008 4:46:50 AM:
3/1/2008 4:46:50 AM: Validating files:
3/1/2008 4:46:50 AM: K:\Backups\Weekly\Freight_2006.sqb
3/1/2008 4:46:50 AM:
3/1/2008 4:46:50 AM: RESTORE VERIFYONLY FROM DISK = 'K:\Backups\Weekly\Freight_2006.sqb'
3/1/2008 5:41:48 AM: Thread 0 error:
Failed to service command. Error code: -2139684860
Process terminated unexpectedly. Error code: -2139684860
Device index out of range: 98
3/1/2008 5:41:48 AM: Thread 1 error:
Failed to service command. Error code: -2139684860
Process terminated unexpectedly. Error code: -2139684860
Device index out of range: 98
3/1/2008 5:41:48 AM: Thread 2 error:
Process terminated unexpectedly. Error code: -2139684860
Device index out of range: 98
SQL error 3013: SQL error 3013: VERIFY DATABASE is terminating abnormally.
SQL error 3203: SQL error 3203: Read on "SQLBACKUP_1CE6FEB1-1C9C-4C13-8F74-08481D08E1A002" failed: 995(The I/O operation has been aborted because of either a thread exit or an application request.)
3/1/2008 5:41:48 AM: Validation of all backup files failed.
3/1/2008 3:05:27 AM: Backing up Freight_2006 (full database) to:
3/1/2008 3:05:27 AM: K:\Backups\Weekly\Freight_2006.sqb
3/1/2008 3:05:27 AM: BACKUP DATABASE [Freight_2006] TO DISK = 'K:\Backups\Weekly\<AUTO>.sqb' WITH NAME = '<AUTO>', DESCRIPTION = '<AUTO>', INIT, VERIFY, MAILTO_ONERROR = 'daniel.britten@prgx.com', COMPRESSION = 1, THREADCOUNT = 3
3/1/2008 4:46:50 AM: Database size : 611.835 GB
3/1/2008 4:46:50 AM: Compressed data size: 172.187 GB
3/1/2008 4:46:50 AM: Compression rate : 71.86%
Processed 329048 pages for database 'Freight_2006', file 'FREIGHT_2006' on file 1.
Processed 31959664 pages for database 'Freight_2006', file 'FREIGHT_2006_DATA1' on file 1.
Processed 23408960 pages for database 'Freight_2006', file 'FREIGHT_2006_DATA2' on file 1.
Processed 23612120 pages for database 'Freight_2006', file 'FREIGHT_2006_IDX' on file 1.
Processed 15896 pages for database 'Freight_2006', file 'FREIGHT_2006_INDEX1' on file 1.
Processed 15944 pages for database 'Freight_2006', file 'FREIGHT_2006_INDEX2' on file 1.
Processed 8 pages for database 'Freight_2006', file 'FREIGHT_2006_Log' on file 1.
BACKUP DATABASE successfully processed 79341640 pages in 6071.381 seconds (107.054 MB/sec).
3/1/2008 4:46:50 AM:
3/1/2008 4:46:50 AM: Validating files:
3/1/2008 4:46:50 AM: K:\Backups\Weekly\Freight_2006.sqb
3/1/2008 4:46:50 AM:
3/1/2008 4:46:50 AM: RESTORE VERIFYONLY FROM DISK = 'K:\Backups\Weekly\Freight_2006.sqb'
3/1/2008 5:41:48 AM: Thread 0 error:
Failed to service command. Error code: -2139684860
Process terminated unexpectedly. Error code: -2139684860
Device index out of range: 98
3/1/2008 5:41:48 AM: Thread 1 error:
Failed to service command. Error code: -2139684860
Process terminated unexpectedly. Error code: -2139684860
Device index out of range: 98
3/1/2008 5:41:48 AM: Thread 2 error:
Process terminated unexpectedly. Error code: -2139684860
Device index out of range: 98
SQL error 3013: SQL error 3013: VERIFY DATABASE is terminating abnormally.
SQL error 3203: SQL error 3203: Read on "SQLBACKUP_1CE6FEB1-1C9C-4C13-8F74-08481D08E1A002" failed: 995(The I/O operation has been aborted because of either a thread exit or an application request.)
3/1/2008 5:41:48 AM: Validation of all backup files failed.
Comments
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8