March 13, 2012 at 9:37 am
Can some help me with script that tells how far log shipping Databases is Out of Sync. In Result set we need in DatabaseName, SyncLatency (in min).? Thnaks in Advance for your help:-)
March 13, 2012 at 9:53 am
here is a query.
exec sp_executesql @stmt=N'exec sp_help_log_shipping_monitor',@params=N''
March 13, 2012 at 10:48 am
Grasshopper
Should i pass any parameter's and i had executed the script and i am getting all the values, which column will tell out of sysnc time in mins? is there any chance we can get result set coulmns as Database and SyncLatency (in min)?
March 14, 2012 at 2:32 am
the following link http://msdn.microsoft.com/en-us/library/ms175106.aspx contains all the objects that are used in logshipping, you should be able to create a query to your needs by selecting from these.
March 15, 2012 at 1:56 am
Hi Antony,
with your suggestion i made below query, can you please guide me weather i am in right way to work our the latency
select secondary_database as Database_Name, datediff(MM,last_restored_date,last_copied_date)as[OUT_SYNC Latency in Mins]
from log_shipping_monitor_secondary:-)
March 15, 2012 at 2:01 am
it seems like you are on the right track, the only way would be to test it, but i dont have a logshipping environment
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply