November 19, 2007 at 6:05 pm
Hi,
I am working on a HA solution for a company where I am likely to implement log shipping in Production. It is a fairly green field project and the servers may be clustered - they will be rack mounted blade servers. I wondered what issues might arise with log shipping on a cluster and how you would have the cluster set up. I am interested in solutions of up to 4 nodes.
I assume that you have to have at least 2 active nodes for this to work because you can't log ship to a passive??
Also, if a server fails over will log shipping fail because the primary to secondary server link is broken or could you have Active / Active / Passive and the Passive picks up and log shipping still works??
I just wondered if anyone can shed any light on this or if any can suggest any useful articles for this situation or list pros and cons (I am waiting on a book from Amazon 'Microsoft SQL Server 2000 High Availability') - any help will be greatly appreciated!
Many thanks,
Phil.
November 19, 2007 at 9:25 pm
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 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply