Log Shipping - Monitor Server

  • 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.

  • 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

  • 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]

  • 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

  • interesting question.

    Tom

  • 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]

  • 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.

    😎

  • 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/

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

  • 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