Post reply

Problem Restoring 2nd and Succeeding Differential Backup

  • June 18, 2009 at 3:18 am

    #1011540

    ps (6/18/2009)

    hi_abhay78 (6/18/2009)

    Why to apply so many differential backups when one would suffice 🙂

    He's restoring to the reporting server everyday morning with diff backup...

    log shipping would have been a better option with restore interval kept to a day.

    edit : added comments.

    Unfortuanately lohipping isn't an option in this case as the production databases are using the simple recovery model. Can't do t-log backups in this case.

    Please note, that if the process I detailed works, you will only have to restore one differentail backup a day, your full backup when ever you take that on your production database, as that will break the chain for your differential backups.

  • June 18, 2009 at 4:11 am

    #1011593

    Lynn Pettis (6/18/2009)[hr

    Unfortuanately lohipping isn't an option in this case as the production databases are using the simple recovery model. Can't do t-log backups in this case.

    Thanks for correcting me once again Lynn 🙂


    Pradeep Singh

Viewing 2 posts - 16 through 16 (of 16 total)

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