I have set up a few log shipping instances, but I am not a DBA.
This weekend something happened for the first time - the log shipping Monitor Server went down temporarily due to electrical issues outside of my control.
When I looked at the primary and secondary machines during this time- both were up and running and the .trn files were still being copied from the primary to the secondary - as expected. Yet, the secondary instance did not restore the .trn files at all. I received a notification:
The log shipping primary database _________ has backup threshold of 60 minutes and has not performed a backup log operation for 82 minutes. Check agent log and logshipping monitor information.
Is this expected? The primary and secondary were both running - shouldnt the monitor be an "optional" SQL instance which should have no effect on the log shipping? It was preventing the secondary instance from applying the backups even though I later explicitly ran the restore job. When the monitor server came back on - everything sorted itself out.
I have a lot to learn I know, any advice on whether I can check some settings or whether this is expected would be appreciated please.