Sql Query to determine when log shipping last took place

Question

2.7k views Asked by KevinT At 16 January 2012 at 08:00

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'

There are 1 answers

**Oleg Dok** · Accepted Answer · 2012-01-16 08:18:24

Oleg Dok On 16 January 2012 at 08:18 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