• sqluser_8119 (6/27/2011)


    Once I do the full backup restore, do I have to apply each differential in order, or can I just apply the last differential from the 25th?

    6/22/11 Full backup

    6/23/11 Diff backup

    6/24/11 Diff backup

    6/25/11 Diff backup

    Followed by gail's reply

    Restore a full backup with norecovery on 6/22/11 +

    Restore a Differential backup with norecovery on 6/25/11

    If you have log backup restore it (with recovery ) after the Differential backup on 6/25/11 in a sequence.

    For more read the bottom of the post.

    Backup types[/url]

    Edited: For more info

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/