Sql Query to determine when log shipping last took place

2.7k views Asked by At

I need a SQL query to determine when log shipping last occured for a given database. Would this be correct?

SELECT  Max(restore_date)
FROM    msdb.dbo.restorehistory 
WHERE   destination_database_name = 'XXXXXXXXXX' AND
        restore_type = 'L'
1

There are 1 answers

0
Oleg Dok On BEST ANSWER

Yes

but

only if you do not restored logs manually last time.

and

better use the procedures at Monitor Instance dedicated to this task