RESTORE LOG is terminating abnormally

kepr00kepr00 Posts: 43 Bronze 2
edited December 18, 2012 8:55PM in SQL Backup Previous Versions
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

Comments

Sign In or Register to comment.