Red Gate forums :: View topic - Restore to point in time from 2 Full backups
Return to www.red-gate.com RSS Feed Available

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

Restore to point in time from 2 Full backups

Search in SQL Backup 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
MartinH



Joined: 15 Apr 2005
Posts: 64

PostPosted: Sat Jun 02, 2012 9:51 am    Post subject: Restore to point in time from 2 Full backups Reply with quote

Hi:

I have 2 full backups, and no log backups were performed between these copies. Is it possible to restore to a point in time between the 2 backups.

Here is what I have:
1) Full copy of 29/4/12 22:00
2) Full copy of 30/4/12 22:00 (no log backup was performed since point 1)
3) I want to restore to a point at 30/4/12 18:00

Is this possible? If so, what steps should I take to perform this?

Thanks,
Martin
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2301

PostPosted: Sat Jun 02, 2012 6:19 pm    Post subject: Reply with quote

Restoring to a point in time is only possible using transaction log backups.
_________________
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
MartinH



Joined: 15 Apr 2005
Posts: 64

PostPosted: Sun Jun 03, 2012 7:58 am    Post subject: Reply with quote

Okay, when I do a Full backup, and don't perform a Log backup, I take it the log is still preserved, so can I now do a Log backup and use that? A Log backup has not been performed yet, so is it still preserved? If so, can I use that Transaction Log to do a restore to a point in time?
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2301

PostPosted: Sun Jun 03, 2012 11:06 am    Post subject: Reply with quote

That should work.
_________________
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
MartinH



Joined: 15 Apr 2005
Posts: 64

PostPosted: Mon Jun 04, 2012 7:37 am    Post subject: Reply with quote

Should I start with restoring the full backup from 29/04/12, and then restore the log to the specified point in time of 30/04/12 18:00?
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2301

PostPosted: Mon Jun 04, 2012 8:19 am    Post subject: Reply with quote

Yes, restore the full backup from April 29 with the NORECOVERY option, followed by the first trx log backup you have made after that full backup.

Unless your recovery models changed between the time of the above 2 backups, or you had bulk-logged trxs, recovering to that point in time should be possible.
_________________
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
MartinH



Joined: 15 Apr 2005
Posts: 64

PostPosted: Mon Jun 04, 2012 11:09 am    Post subject: Reply with quote

Thanks to all who have contributed.

I have managed to recover the data I was interested in. Lots of lessons have be learnt, and once again Redgate make this all so easy.

Great job guys!
Back to top
View user's profile Send private message
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