Log Shipping - Monitor Server

  • Raghavendra Mudugal

    SSChampion

    Points: 10658

    Comments posted to this topic are about the item Log Shipping - Monitor Server

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • Lokesh Vij

    SSChampion

    Points: 10836

    Nice question Raghu! Thanks for posting 🙂

    ~ Lokesh Vij


    Guidelines for quicker answers on T-SQL question[/url]
    Guidelines for answers on Performance questions

    Link to my Blog Post --> www.SQLPathy.com[/url]

    Follow me @Twitter

  • Jan Van der Eecken

    SSCrazy Eights

    Points: 8890

    Maybe I should have read the question properly? I knew you can configure the monitor server to record the status and historic information about log shipping jobs. But that's not what the question was. It says CANNOT monitor.

    Wondering how many more people will make that mistake. 😎

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

  • Koen Verbeeck

    SSC Guru

    Points: 258907

    Nice easy question, thanks.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • This was removed by the editor as SPAM

  • TomThomson

    SSC Guru

    Points: 104763

    interesting question.

    Tom

  • DugyC

    Hall of Fame

    Points: 3804

    Jan Van der Eecken (12/4/2012)


    Maybe I should have read the question properly? I knew you can configure the monitor server to record the status and historic information about log shipping jobs. But that's not what the question was. It says CANNOT monitor.

    Wondering how many more people will make that mistake. 😎

    +1

    Bak 2 Skool for me, learn to read again :doze:

    _____________________________________________________________________
    [font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]

  • SanDroid

    SSChampion

    Points: 10068

    Nice easy question. Good to note this about log shipping:

    "To monitor a log shipping configuration, you must add the monitor server when you enable log shipping. If you add a monitor server later, you must remove the log shipping configuration and then replace it with a new configuration that includes a monitor server. "

    I am sure this is what the question author was thinking about when he wrote the question.

    😎

  • lptech

    Hall of Fame

    Points: 3188

    Here is a link of how to add monitoring after the fact:

    http://www.mssqltips.com/sqlservertip/2799/steps-to-add-log-shipping-monitor-into-an-existing-sql-server/

  • Ken Wymore

    SSCoach

    Points: 16354

    Nice question. Yet another topic for me to read up on.

  • (Bob Brown)

    SSCrazy

    Points: 2705

    Thanks for the question.

Viewing 11 posts - 1 through 11 (of 11 total)

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