Post reply

Log shipping Monitor server in SQL server 2005

  • February 21, 2007 at 7:45 am

    #172145

    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

    #690902

    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

    #691084

    How about 

    msdb.dbo.log_shipping_monitor_primary?

     

    AucklandSQL User Group
    Independent SQL Server Consultant
    SQL Server MVP

  • February 22, 2007 at 5:14 am

    #691114

    I query msdb.dbo.log_shipping_monitor_secondary.

    My blog: SQL Soldier[/url]
    SQL Server Best Practices:     SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply