Forum Patrons,
Your advise in the past was great and after this problem with Log Shipping error couldn't find the relevant answer from BOL.
The Log Shipping was broken and found the intruder on the Secondary server where the operation on to Sharing File Drive has performed with FILE Transfer where the COPY - LOG BACKUPS were storing.
Date 25/06/2018 6:12:00 PM
Log Job History (LSAlert_DRserver)
Step ID 1
Server DRserver
Job Name LSAlert_DRserver
Step Name Log shipping alert job step.
Duration 00:00:00
Sql Severity 16
Sql Message ID 14421
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0
Message
Executed as user: xxxxx\x-sql-dr. The log shipping secondary database DRserver.DB1_DEV has restore threshold of 6 minutes and is out of sync. No restore was performed for 406 minutes. Restored latency is 6 minutes. Check agent log and logshipping monitor information. [SQLSTATE 42000] (Error 14421). The step failed.
Primary Server ALERT and BACKUP working.
Secondary Server COPY working but not RESTORE ans subsequently ALERT is failing with above error.
Your expert advise will surely help me as in the previous occasions.
Thanks in advance