February 21, 2007 at 7:45 am
Hi All,
Can someone tell me how to find the monitor server for the log shipping pairs. I could not find any information in Primary and secondary server. Any DM views that will help me!
Thanks in advance.
Helen
--------------------------------
Are you a born again. He is Jehova Jirah unto me
February 21, 2007 at 7:51 am
Helen
I have an entire failover system for 25 separate clients setup using the 2005 log shipping. Has been in production for 6 months with no problems.
Are you looking for the monitor job that runs under the SQL Server Agent? This is a job that gets created by the system.
Call if this is not what your looking for
Eric
(678) 336-2295
February 22, 2007 at 1:43 am
How about
msdb.dbo.log_shipping_monitor_primary?
February 22, 2007 at 5:14 am
I query msdb.dbo.log_shipping_monitor_secondary.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply