Restore to point in time from 2 Full backups

• 
  Restoring to a point in time is only possible using transaction log backups.

  petey June 02, 2012 13:19

  - 0 +
• 
  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?

  MartinH June 03, 2012 02:58

  - 0 +
• 
  That should work.

  petey June 03, 2012 06:06

  - 0 +
• 
  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?

  MartinH June 04, 2012 02:37

  - 0 +
• 
  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.

  petey June 04, 2012 03:19

  - 0 +
• 
  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!

  MartinH June 04, 2012 06:09

  - 0 +

Add comment

Please sign in to leave a comment.