What are the challenges you face when working across database platforms? Take the survey
Options

SQL Backup failed with exit code 820: SQL error code: 3203

DanielBrittenDanielBritten Posts: 15 Bronze 2
edited March 4, 2008 8:22PM in SQL Backup Previous Versions
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.

Comments

  • Options
    peteypetey Posts: 2,358 New member
    Please upgrade to version 5.3, as it contains a fix that addresses this issue. Note that you're already using version 5, although you've posted your question to the version 4 forum. Version 4 did not include the THREADCOUNT option.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
Sign In or Register to comment.