| Author |
Message |
kepr00
Joined: 28 Nov 2006 Posts: 25
|
Posted: Fri Dec 14, 2012 11:11 am Post subject: RESTORE LOG is terminating abnormally |
|
|
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 |
|
| Back to top |
|
 |
petey
Joined: 24 Apr 2005 Posts: 2219
|
Posted: Wed Dec 19, 2012 2:55 am Post subject: |
|
|
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 |
|
| Back to top |
|
 |
|
|
All times are GMT + 1 Hour
|
| Page 1 of 1 |
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group