SQL error 3013 Backup Database is terminating abnormally

Compresses, encrypts, secures and monitors SQL Server backups.

Moderators: JonathanWatts, Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey

SQL error 3013 Backup Database is terminating abnormally

Postby pcrxtech » Wed Dec 04, 2013 8:51 pm

We have a backup job which backing up 5 databases and 4 out of 5 as are running OK. however one database keep failing for full and increment too.

Searched forum for error code. and there was one topic which has same error but it also has a line for memory issue. however there is no mention for memory so I created new topic.

Can you take a look at this log please?


SQL error 3013: BACKUP DATABASE is terminating abnormally.
SQL error 3271: A nonrecoverable I/O error occurred on file "SQLBACKUP_02C205BD-4A11-431F-AF1A-84F77F20BA3F:" 995(The I/O operation has been aborted because of either a thread exit or an application request.).
SQL error 3043: BACKUP 'Interfax' detected an error on page (1:8650358) in file 'G:\\Data\\Interfax_DataNew.MDF'.
Thread 0 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
Thread 1 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
Thread 2 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
Thread 3 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
Thread 4 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
Thread 5 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
Thread 6 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
Thread 7 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
Thread 8 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
Thread 9 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
Thread 10 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
Thread 11 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
Thread 12 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
Thread 13 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
Thread 14 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
pcrxtech
 
Posts: 1
Joined: Wed Dec 04, 2013 8:35 pm
Location: United States

Postby petey » Mon Dec 09, 2013 2:52 pm

Based on the following in the output:

SQL error 3043: BACKUP 'Interfax' detected an error on page (1:8650358) in file 'G:\\Data\\Interfax_DataNew.MDF'.

It looks like your database has a consistency issue. Try running DBCC CHECKDB on that database to see if the same error is reported.
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
petey
 
Posts: 2234
Joined: Sun Apr 24, 2005 12:34 pm


Return to SQL Backup 7

Who is online

Users browsing this forum: No registered users and 0 guests