Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2009
    Posts
    73

    Question Unanswered: Restore strategy Sequence

    If i took full backup at 3:00 am
    then i took diffrential backup at 6:00 am

    then T-log backups every 10 mins starting at 6:10am till 11:00am

    then diffrential backup at 11:10 am

    then i took T-Log backup at 11:20 am

    and suddently database fails at 11:23am

    whats going to be the sequence of restore

    As per me ... restore full backup , then restore diffrential backup which was taken at 11:10 am then T- log Backup which was taken at 11:20 am

    i will neglect all t-logs between 6:10 am to 11:00 am
    i will neglect all diffrential backups taken before 11:10 am

    Is my strategy right Pls help I am new to this!!!!!

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    That is essentially correct. If at all possible, you could take a backup of the transaction log after the failure to get the last 3 minutes back, as well. This would of course require that the database be up and running at that point.

  3. #3
    Join Date
    Aug 2009
    Posts
    73
    Thank You So much !! i really appreciate

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •