Post reply

Logshipping failover - how do i know which trnlogs are applied

  • October 7, 2010 at 11:34 pm

    #230095

    Hi,

    i;m new to log shipping,

    In log shipping Failover to secondary database, how do i know that which transactions log files are restored and what are the transactions files to restore to secondary db

    thanks,

    🙂

  • October 8, 2010 at 8:13 am

    #1234291

    Hi,

    Can query log_shipping_monitor_secondary table in MSDB for last copied and last restored files.

    Thank you

    [font="Verdana"]Renuka__[/font]

  • October 8, 2010 at 5:07 pm

    #1234576

    answer above is the best way to do it but log restores are also recorded in the errorlog

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

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

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