RESTORE LOG 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

RESTORE LOG is terminating abnormally

Postby kepr00 » Fri Dec 14, 2012 11:11 am

Hello,
I am receiving the following errors in the sql log.

12/14/2012 2:47:58 AM: Thread 0 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
12/14/2012 2:47:58 AM:
12/14/2012 2:47:58 AM: SQL error 3013: SQL error 3013: RESTORE LOG is terminating abnormally.
12/14/2012 2:47:58 AM: SQL error 3254: SQL error 3254: The volume on device 'SQLBACKUP_638113BA-9C82-4D44-96BF-EB8D63C21227' is empty.

Although the error seems to indicate an issue, the log restore itself seems to have worked fine. When I check the data in the database, it is up to date.

Below is the full error log from sql backup.

SQL Backup log file 7.2.1.82
-SQL "RESTORE LOG [MyDB] FROM DISK = 'D:\\DBMIncoming1\\MyServer_MyDB_40529000001080300001_20121213_101511_LOG.sqb' WITH REPLACE, STANDBY = 'D:\\DBMIncoming1\\StandByFiles\\MyDB.undo', FILEOPTIONS = 1, ERASEFILES = 1, PASSWORD = 'XXXXXXXXXX', MOVETO = 'D:\\DBMIncoming1\\Complete\\MyDB' "

----------------------------- ERRORS AND WARNINGS -----------------------------


12/14/2012 2:47:58 AM: Restoring MyDB (transaction logs) from:
12/14/2012 2:47:58 AM: D:\\DBMIncoming1\\MyServer_MyDB_40529000001080300001_20121213_101511_LOG.sqb

12/14/2012 2:47:58 AM: RESTORE LOG [MyDB] FROM VIRTUAL_DEVICE = 'SQLBACKUP_638113BA-9C82-4D44-96BF-EB8D63C21227' WITH BUFFERCOUNT = 6, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576 , STANDBY = N'D:\\DBMIncoming1\\StandByFiles\\MyDB.undo', REPLACE

12/14/2012 2:47:58 AM: Thread 0 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
12/14/2012 2:47:58 AM:
12/14/2012 2:47:58 AM: SQL error 3013: SQL error 3013: RESTORE LOG is terminating abnormally.
12/14/2012 2:47:58 AM: SQL error 3254: SQL error 3254: The volume on device 'SQLBACKUP_638113BA-9C82-4D44-96BF-EB8D63C21227' is empty.
Steve T
kepr00
 
Posts: 25
Joined: Tue Nov 28, 2006 8:42 pm

Postby petey » Wed Dec 19, 2012 2:55 am

Could you please send me the file 'MyServer_MyDB_40529000001080300001_20121213_101511_LOG.sqb'? My e-mail address is peter.yeoh@red-gate.com.

Thanks.
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
petey
 
Posts: 2233
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