Combining Clustering and Log Shipping in SQL 2000

  • I haven't played with Mirroring enough to be of any help to you on tips and tricks, but I can help you a little as to the licensing. Here's the "official" version of the "letter of the law":

    http://www.microsoft.com/sql/howtobuy/activepassive.mspx

    Cliffs notes version: if the ONLY thing the additional nodes are doing (be they inactive cluster nodes, mirrors, or log shipping recipients) is to be the passive node, then no additional licensing is required. So - if you set up mirroring, and use the mirror instance of SQL server for NOTHING other than processing the mirror traffic (and that includes not using it as a reporting server, etc..), then you do NOT need an additional license.

    The minute you DO use it for anything else SQL-related, then of course, this goes out the window.... and everything need to be licensed....

    Hope that helps....

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

Viewing post 1 (of 2 total)

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