• Sudhakar Vallamsetty (9/18/2012)


    Get the last successfully restored t-log from LS tables present in MSDB database and apply subsequent t-log backups from Primary server on Secondary server(make sure you disable the LS restore job while doing)

    If these are missing then this won't work. Also, even if they do exist it can be a real pain to start restoring lots and lots of logs, a differential backup from the primary restored to the secondary is quick and easy and will bridge any LSN gaps 😉

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉