Post reply

Set up Log Shipping off an already existing full backup and tran log backup

  • March 26, 2010 at 3:35 pm

    #231258

    Hi everyone,

    I'm a little new with log shipping implementation. I have a full backup of my target db and then a tran log backup after that. I want to restore both of those to a secondary server and leave the server in stand-by mode. I restored the full just fine, and it created the ROLLBACK_UNDO.BAK file. My question is how do I apply that as I restore the tran log after that. When I attempted it went to create the the ROLLBACK_UNDO.BAK file again (with the same name). Shouldn't the orig one be applied during the tran log restore and then a new file get created that gets applied by the log shipping once that starts running?

    Thanks in advance,

    Arturo

  • March 29, 2010 at 8:15 am

    #1141457

    I see it was a silly question now. All but the last restores should be RESTORE WITH NO RECOVERY and the last restore can be the one with RESTORE WITH STANDBY.

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

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