I have setup log shipping and all the jobs backup,copy and restore jobs are running fine without any issues.
But the Alert job on primary server keeps on triggering alert with the below error:
The log shipping secondary database has restore threshold of 45 minutes and is out of sync. No restore was performed for 692516 minutes. Restored latency is 0 minutes. Check agent log and logshipping monitor information. [SQLSTATE 42000] (Error 14421). The step failed.
Thanks for the help.