Posting Yak Master
Posted - 07/15/2008 : 10:30:46
| Hi All,
I have questions. I have SQL 2003 Windows server with SQL server 2005 and litespeed4.602 version.
I have configured the logshipping theu litespeed. I want to see is Logshippinig is in sync or not?
I know I can check by SQL logs and windows log, But I want to see with T-SQL for Litespeed.
Here is the TSQL for litespeed. I can not see any error but I know the logshipping is not sync.
SELECT * FROM LitespeedLocal..litespeedactivity
WHERE starttime > DATEADD(mi, -60, GETDATE())
ORDER BY starttime
Could any one know how to check the in-Sync or Out of Sync status of the litespeed logshipping?