Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mdubey
Posting Yak Master
133 Posts |
 Posted - 2008-07-15 : 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 starttimeCould any one know how to check the in-Sync or Out of Sync status of the litespeed logshipping?ManojMCP, MCTS |
|
|
bkharel
Starting Member
1 Post |
Posted - 2014-01-10 : 14:54:14
|
| Run the following system stored Procedure across master database:use master sp_check_log_shipping_monitor_alertThis will give you the result if databases are in sync or not.If in sync - then you get commands run successfully If out of sync- you get the message like (The log shipping secondary database XXXX has restore threshold of XX minutes and is out of sync. No restore was performed for XX minutes. Restored latency is XXXX minutes. Check agent log and logshipping monitor information.) |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-01-10 : 15:08:44
|
| I doubt sp_check_log_shipping_monitor_alert will provide the needed info when the log shipping solution is through Litespeed and not the built-in 2005 log shipping. Hopefully Manoj found a suitable answer for Litespeed 5 years ago.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
How to check SQL Litespeed Logshipping in SYNC