Is there a query or report to see how often log shipping fell behind for a given month?

Behind by 2 minutes is fine. Behind 1+ hours several times a month is not.


1 Answer 1


Try querying the backup sets for the time restored vs. the time taken of each log backup. - user240213

There's nothing built in for a given month, you will have to roll your own. A good start is Monitor Transaction Log shipping using T-SQL and SSMS by Jignesh Raiyani. - user48093

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.