Home Forums SQL Server 2008 SQL Server 2008 High Availability LsAlert job is failing on Primary Instance RE: LsAlert job is failing on Primary Instance

  • October 28, 2016 at 2:36 pm

    #1909436

    juniorDBA13 (10/28/2016)

    I have reconfigured logshipping but my LSAlert job on the primary is still failing.

    On the secondary the transaction log shipping status report is showing OK, logs are being copied and restored.

    The transaction log shipping status report on the primary is showing restore/copied information from before it was recreated logshipping.

    Please advise how i can resolve this?

    The tables used for monitoring could be stale. You can try updating those by executing sp_refresh_log_shipping_monitor on the secondary server.

    Sue