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

  • HI, Anthony

    Its 5mins for each

    1. same issue came early for two database at that time i performed manaul Full backup using GUI and restore in secondary with (leave the database in read-only mode)

    2. later i executed manualy LSbackup job in primary and LScopy and LSrestore in secondary

    3. refresh the primary and secondary then issue solved and the LSAlerts in Primary and Secondary excuting normaly "I don't know this is correct or not but it happend"

    4. ivl monitor for some more time if the same continues ivl reconfigure the logshipping

    5. but before that i want to know the actuall technical reason for this ,It may happen again in future its not right to reconfigure logshipping always

    Thanks&Regards

    NAGA.ROHITKUMAR

    Thanks
    Naga.Rohitkumar