Post reply

Differential Backup restore sequence

  • June 8, 2015 at 7:55 am

    #301385

    I Have a testdb and i had taken a FULL Backup after inserting 1000 records,

    And After inserting 500 Records i had taken DIFF Backup 1

    And after inserting 250 Records i had taken DIFF backup 2

    And again after inserting 100 Records i had taken DIFF Backup 3

    And Finally a LOG Backup

    Now my question is After taking the third DIFF3 Backup will the DIFF 1 and DIFF 2 backups are included in DIFF3 or they will be neglected

    so that my restore sequence can be FULL Backup + DIFF 3 + Log Backup

    Is this correct sequence

    ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Save a tree... Please don't waste paper unless you really need to!

    When life puts into problem don't say 'God Why Me' say:w00t: 'Try Me'

  • June 8, 2015 at 8:06 am

    #1803691

    There can be more than one correct answer here, including just restoring the last log backup.

    Are we correct in assuming that you want the correct sequence that starts with restoring the last full backup.


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • June 8, 2015 at 8:41 am

    #1803711

    Please don't post multiple threads for the same question. You've got about 5 different threads on restore sequences, one would have been quite adequate.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply