Red Gate forums :: View topic - RESTORE LOG is terminating abnormally
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 7
SQL Backup 7 forum

RESTORE LOG is terminating abnormally

Search in SQL Backup 7 forum
Post new topic   Reply to topic
Jump to:  
Author Message
kepr00



Joined: 28 Nov 2006
Posts: 25

PostPosted: Fri Dec 14, 2012 11:11 am    Post subject: RESTORE LOG is terminating abnormally Reply with quote

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
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2299

PostPosted: Wed Dec 19, 2012 2:55 am    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic 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