Environment and Server Details:
- Windows Server 2012 R2 standard
- VMWare Virtual Machine
- Dell Equal Logic SAN
SQL Error Log Message:
The log shipping secondary database ServerName.DatabaseName has restore threshold of 45 minutes and is out of sync. No restore was performed for 34089 minutes. Restored latency is 2 minutes. Check agent log and log shipping monitor information.
I've verified that the logs are being restored on the log shipping secondary, matched up the LSNs, also, I have the Log Shipping Monitor from Red Gate that verifies my logs are up to date. Further, the aforementioned error message is for every database in the instance.
I've built a similar setup in a lab environment and I get the same error messages.
- What gives, anyone have any insight?
- Can I safely ignore these messages since I know the logs are being
backed up, copied, and restored?
Having 10s of thousands of error messages per week makes it pretty difficult to peruse and check other possible issues