RESTORE LOG is terminating abnormally
kepr00
Posts: 43 Bronze 2
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:
\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.
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:
\DBMIncoming1\MyServer_MyDB_40529000001080300001_20121213_101511_LOG.sqb12/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
Thanks.
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8