Red Gate forums :: View topic - Restore Logs error
Return to www.red-gate.com RSS Feed Available

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

Restore Logs error

Search in SQL Backup Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
dwjongbloed



Joined: 26 Nov 2007
Posts: 15
Location: Willmar, MN

PostPosted: Thu Aug 26, 2010 1:14 pm    Post subject: Restore Logs error Reply with quote

I have a job that restores a Full backup at 2:30 am. The Full backup is taken at 12:30 am. The restore leaves the database to where I can restore the logs if needed. However when I try to go and restore the logs I get SQL Error 4305: The log in this backup set begings at LSN XXXX, whi is too recent to apply to the database. An earlier log backup that includes LSN XXXX can be restored.

I was trying to restore the log backup from 1 am.

Can anyone help me out on this? What is going on?
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2306

PostPosted: Mon Aug 30, 2010 8:02 am    Post subject: Reply with quote

It looks like there was another transaction log backup taken before 1 am. Try looking in the msdb..backupset table and check if there were any log backups taken before 1 am.

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