Hi,

log shipping restore job got failed due to below error. i find that error from alert job. please assistance how to troubleshoot that.

The log shipping secondary database XXXXXXXDATA.XX_DB has restore threshold of 45 minutes and is out of sync. No restore was performed for 193 minutes. Restored latency is 6 minutes. Check agent log and logshipping monitor information. [SQLSTATE 42000] (Error 14421). The step failed.

and also i checked the log_shipping_monitor_secondary table on secondary server i got the error like restore failed due database in use .