locked
Point-in-time restore questions RRS feed

  • Question

  • Assume one has been taking full backups along with TLog backups and we keep 1-2 weeks worth of backups before deleting older files.  Can one restore a Db to a point in time, say 4-5 weeks ago?
    Thursday, October 18, 2018 7:23 PM

Answers

  • Do you really need to even think about this? Your oldest full backup (which is a required starting point) is no older than 2 weeks. You cannot restore to a point in time prior to your oldest full backup. 
    • Marked as answer by shiftbit Thursday, October 18, 2018 7:44 PM
    Thursday, October 18, 2018 7:35 PM

All replies

  • Do you really need to even think about this? Your oldest full backup (which is a required starting point) is no older than 2 weeks. You cannot restore to a point in time prior to your oldest full backup. 
    • Marked as answer by shiftbit Thursday, October 18, 2018 7:44 PM
    Thursday, October 18, 2018 7:35 PM
  • you can

    just apply latest full backup before the period (4-5 weeks)

    then apply Tlog backups sequential until point in time you want


    Please Mark This As Answer if it solved your issue
    Please Vote This As Helpful if it helps to solve your issue
    Visakh
    ----------------------------
    My Wiki User Page
    My MSDN Page
    My Personal Blog
    My Facebook Page

    Thursday, October 18, 2018 7:36 PM