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

  • naga.rohitkumar (9/3/2012)


    HI,

    1. LSAlert job fails in job activity monitor in both DC & DR (Primary & secondary) servers in logshipping

    2. While manualy executing it is failing and msg in hisroty is "[[r] database] has backup threshold of 60 minutes and not performed a backup log operation "

    3. Except this all my LSBackup jobs and LSCopy & LSRestore jobs are executing succes fully

    4. In which conditions this type of issue comes and how to get reid of this and make the alerts working properly in both DC & DR

    Thanks & regards

    NAGA.ROHITKUMAR

    Although the jobs are marked as executed successfully, thoroughly check the output for each step of each job, you'll likely find there are some errors. Post detail of these for us to help you further

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

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