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

SQLBackup just stopped working, for no apparent reason..

cluthycluthy Posts: 8
First off, I'm running SQL Backup 5.2.0.2824, SQL Server 2005 Ent x64 + SP2, Windows Server 2003 R2 Ent x64.
SQL Backup has been working fine, without any issues, for months now.

Last night I get an error email from SQL Agent specifying that our SQL Backup (User DB's) job failed.
The User DB backup job runs SQLBackup with the syntax: "backup databases [A,B,C,D,E,F,G,H,I,J,K] to disk = [\\dataarchiveserver\sqlbackup\<auto>]".
In the case of the automated run (the one that first failed and therefore sent me an error email), it failed on database "I" (by far the largest DB on the server). All other backups completed successfully.

I checked free space on the destination share (there was more than enough), so I manually re-ran the same code that the job runs in a query in Management Studio.
The same error happens, but this time it fails on database "D" (one of the smaller DB's on the server). All other backups completed successfully.
I then open a new query, re-run the job AGAIN, but this time only on database "D", as follows: "backup database [D] to disk = [\\dataarchiveserver\sqlbackup\<auto>]".
That time, the backup completed successfully.


Here is all the pertinent info I can think of to include.

SQL Server error message was:
--------------------------------------------------------------------------------
Msg 50000, Level 16, State 1, Line 6
SQL Backup failed with exit code: 790  SQL error code: 3202
--------------------------------------------------------------------------------

Output from manual run of SQLBackup:
--------------------------------------------------------------------------------
Backing up CS_MSCRM_Supplemental &#40;full database&#41; to: 
  \\DataArchive.CS.com\SQLBACKUP\SQLBACKUP\CSSQL4\CS_MSCRM_Supplemental\FULL_&#40;local&#41;_CS_MSCRM_Supplemental_20071217_023630.sqb
 
Thread 0 error: 
Process terminated unexpectedly. Error code: -2139684860
Thread 1 error: 
Process terminated unexpectedly. Error code: -2139684860
Thread 2 error: Backup error: Access violation at address 10009801 in module 'zlib1.dll'. Read of address 063B2000
Thread 3 error: 
Process terminated unexpectedly. Error code: -2139684860
 
Database size       : 1.555 GB
Compressed data size: 1.000 KB
Compression rate    : 100.00%
 
SQL error 3013: SQL error 3013: BACKUP DATABASE is terminating abnormally.
SQL error 3271: SQL error 3271: A nonrecoverable I/O error occurred on file "SQLBACKUP_655BBCBB-B278-4CC2-B57B-C2E3FA2B8E59:" 995&#40;The I/O operation has been aborted because of either a thread exit or an application request.&#41;.
SQL error 3202: SQL error 3202: Write on "SQLBACKUP_655BBCBB-B278-4CC2-B57B-C2E3FA2B8E5902" failed: 995&#40;The I/O operation has been aborted because of either a thread exit or an application request.&#41;
--------------------------------------------------------------------------------

Corresponding SQLBackup Log file entry:
--------------------------------------------------------------------------------
12/17/2007 2:36:30 AM: Backing up CS_MSCRM_Supplemental &#40;full database&#41; to: 
12/17/2007 2:36:30 AM:   \\DataArchive.CS.com\SQLBACKUP\SQLBACKUP\CSSQL4\CS_MSCRM_Supplemental\FULL_&#40;local&#41;_CS_MSCRM_Supplemental_20071217_023630.sqb

12/17/2007 2:36:30 AM: BACKUP DATABASE &#91;CS_MSCRM_Supplemental&#93;  TO DISK = '\\DataArchive.CS.com\SQLBACKUP\SQLBACKUP\CSSQL4\&lt;database&gt;\&lt;AUTO&gt;.sqb' WITH NAME = '&lt;AUTO&gt;', DESCRIPTION = '&lt;AUTO&gt;', INIT, ERASEFILES_ATSTART = 31, COMPRESSION = 3, THREADCOUNT = 4

12/17/2007 2:36:33 AM: Deleting old backup file: \\DataArchive.CS.com\SQLBACKUP\SQLBACKUP\CSSQL4\CS_MSCRM_Supplemental\FULL_&#40;local&#41;_CS_MSCRM_Supplemental_20071116_021750.sqb
12/17/2007 2:36:35 AM: Thread 0 error: 
Process terminated unexpectedly. Error code: -2139684860
12/17/2007 2:36:35 AM: Thread 1 error: 
Process terminated unexpectedly. Error code: -2139684860
12/17/2007 2:36:35 AM: Thread 2 error: Backup error: Access violation at address 10009801 in module 'zlib1.dll'. Read of address 063B2000
12/17/2007 2:36:35 AM: Thread 3 error: 
Process terminated unexpectedly. Error code: -2139684860

12/17/2007 2:36:36 AM: Database size       : 1.555 GB
12/17/2007 2:36:36 AM: Compressed data size: 1.000 KB
12/17/2007 2:36:36 AM: Compression rate    : 100.00%

SQL error 3013: SQL error 3013: BACKUP DATABASE is terminating abnormally.
SQL error 3271: SQL error 3271: A nonrecoverable I/O error occurred on file "SQLBACKUP_655BBCBB-B278-4CC2-B57B-C2E3FA2B8E59:" 995&#40;The I/O operation has been aborted because of either a thread exit or an application request.&#41;.
SQL error 3202: SQL error 3202: Write on "SQLBACKUP_655BBCBB-B278-4CC2-B57B-C2E3FA2B8E5902" failed: 995&#40;The I/O operation has been aborted because of either a thread exit or an application request.&#41;
--------------------------------------------------------------------------------




Any help would be greatly appreciated.

Regards,
Chris

Comments

Sign In or Register to comment.