Post reply

How to know the last applied Transaction log

  • November 2, 2009 at 11:18 pm

    #211765

    Hi,

    We have configured log shipping and wants to failover to secondary. We have 12 databases involved in log shipping. I want to know Is there any query to know the last applied log backup (last restored log backup on secondary) for all databases in one shot?

    right now I'm checking in the error log for last restored log backup but Its a lengthy process to verify every time in error log?

    please advice

    thanks

  • November 2, 2009 at 11:41 pm

    #1074120

    Hi,

    Select * From dbo.log_shipping_monitor_secondary

    Select * From dbo.log_shipping_monitor_error_detail

    U can find details about last restore....

    All d best.. 🙂

    GaNeSH

  • November 3, 2009 at 12:28 am

    #1074132

    it should be run in msdb

    GaNeSH

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

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