Logshipping failover - how do i know which trnlogs are applied

• SQL*

  SSCertifiable

  Points: 6638

  More actions

  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,

  🙂

• Renuka__

  Hall of Fame

  Points: 3656

  More actions

  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]

• george sibbald

  SSC Guru

  Points: 104210

  More actions

  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

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