Post reply

SQL Server 2000 -- Log Shipping Monitor Server

  • June 13, 2006 at 1:24 am

    #61909

    According to the Books Online, all servers used in Log Shipping must have SQL Server 2000 Enterprise Edition installed. My question is does this requirement include the Monitor Server?

  • June 13, 2006 at 2:39 am

    #643302

    Mark,

    you should be able to set up a monitor server on standard edition. I just checked, and standard edition comes with various log shipping procedures in msdb, including sp_add_log_shipping_monitor_jobs, sp_add_log_shipping_primary and sp_add_log_shipping_secondary, which are all used to set up monitoring.

    So my guess is that you can. Having said that, I've never tried this out so I cannot say for sure.

    Your best bet is to try it out.

    Karl
    source control for SQL Server

  • June 13, 2006 at 2:46 am

    #643304

    Thanks, I will give it a try anyway.

  • June 15, 2006 at 3:44 am

    #643894

    Hi, just to confirm....you dont need Ent Edition for the  monitor.

  • June 15, 2006 at 4:48 am

    #643906

    Thank you for the response. Yet another example of the documentation leading me astray 🙂

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

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