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

    Question Unanswered: Will This Restore Strategey Work

    I am taking Full backup every night 9:00pm
    next day i took T-log backups at 6:00 am at every 10 mins till 9:30 am

    at 9:35 am i took diffrential backup

    then from 9:40am till 2:30 pm t-log backups again




    if i plan to restore at time of failure...guess failure occurs 1:00Pm

    My question is which restore strategy is correct ...and will both of them work
    Case#1
    1. I will restore Full backup first
    2 I will restore all T-logs which were taken from 6:00 am till 9:30 am
    3. I will restore all T-logs which were taken from 9:40 am till 1:00 pm

    In above scenario i am not restoring any diffrential, backups

    Case#2

    1. I will restore Full backup first
    2 I will restore diffrential backup taken at 9:35 am
    3. I will restore all T-logs which were taken from 9:40 am till 1:00 pm



    of the two cases which strategy is correct .....

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Which one do you suspect is correct?

  3. #3
    Join Date
    Aug 2009
    Posts
    73
    As per me both are correct ...But i am not sure

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    What doubt do you have? Or in other words, can you argue either approach is valid or not valid?

  5. #5
    Join Date
    Aug 2009
    Posts
    73
    well my question is .. are the both approaches correct ...or you see any flaw in any of them?

  6. #6
    Join Date
    May 2010
    Posts
    7

    hi anit

    Its good to use the second case coz you already have a diff backup

  7. #7
    Join Date
    Mar 2009
    Location
    Australia
    Posts
    113
    Both strategies will have equal success and give identical end results.

    The latter however will take less effort as you would be replacing 22 or so transaction log restores with one differential restore.

Posting Permissions

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