Post reply

log shipping

  • August 11, 2010 at 6:24 am

    #238835

    suppose i configured log shipping and transaction log backup is taken and restored in every hour.

    in between some other guy come an took a transaction log backup at any other place.

    so what to do in that case?????

    i have been asked it in an interview

    can any body tell what wud be the best answer for that???

  • August 12, 2010 at 7:16 am

    #1205985

    Hi,

    I am just playing with log shipping now a days.

    so just find some where in that case you have to re do log shipping work.

    Thanks

    Rajat

  • August 12, 2010 at 7:38 am

    #1206007

    Without that other log backup you are hosed. You either have to get that other backup file and apply it somehow or start over and redo log shipping with a fresh full backup taken after the rogue log backup was taken. The log chain was broken.

  • August 12, 2010 at 10:07 am

    #1206159

    If the log backup was taken with the log backup job just run at a non-scheduled time, you don't have to do anything.

    If someone went and manually ran a backup log ... command on it, you need to manually apply that log to your subscriber once the restore job gets to that point and fails.

    If you dont have access to that log, you need to delete all old txn logs, take a new full backup, restore the db, and then it should pick up ok without having to recreate the LS jobs.

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

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