Home Forums SQL Server 2008 SQL Server 2008 High Availability LSAlert job fails in job activity monitor in both DC & DR (Primary & secondary) servers in logshipping RE: LSAlert job fails in job activity monitor in both DC & DR (Primary & secondary) servers in logshipping

  • September 3, 2012 at 6:17 am

    #1532943

    naga.rohitkumar (9/3/2012)

    HI,

    As u mentioned i checkd the logs in sqlserver and event viewer

    even after all jobs are executed success fully i got this mesage

    the error message is : Logshipping secondary database has restore threshold 45 minutes and it is out of sync.no restoer was performed 2464 minutes. Restore latency is 10 minutes

    Thanks & regards

    NAGA.ROHITKUMAR

    For some reason logs are not being restored. Anthony has already provided one reason, are you taking log backups outside of the LS plan.

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

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