March 18, 2008 at 2:39 pm
I need to set up a 2 node multi-instance SQL Server 2005 cluster (active/active). Since each node will failover to the other, can I use SQL Server 2005 Standard Edition on each node or do I need to use Enterprise Edition?
March 18, 2008 at 2:42 pm
you can use standard. Its only limitation (cluster-wise) is it only goes up to two nodes, which is what you have got. No. of instances, active\passive or active\active is not relevant to thisi
---------------------------------------------------------------------
March 24, 2008 at 12:37 pm
george sibbald (3/18/2008)
you can use standard. Its only limitation (cluster-wise) is it only goes up to two nodes, which is what you have got. No. of instances, active\passive or active\active is not relevant to thisi
Well considering he needs to license 2 servers in an Active/active scenario, and only one in an Active/Passive (yes - even with Standard) - I'm not sure I follow how that's not "relevant" to the scenario.
Active/Active by definition fails the "passive failover" test, so you have to license the 2 clusters assuming the two instances will be by default running on distinct nodes.
----------------------------------------------------------------------------------
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?
March 24, 2008 at 12:49 pm
Matt, Pauls question was could he use standard edition in a two node cluster or would he have to use enterprise edition. The answer is yes he can use standard as there are only two nodes, whether active\active or active\ passive, so the answer is the same whichever set up, hence my use of the term not relevant 🙂
---------------------------------------------------------------------
March 24, 2008 at 12:51 pm
Well considering he needs to license 2 servers in an Active/active scenario, and only one in an Active/Passive (yes - even with Standard) - I'm not sure I follow how that's not "relevant" to the scenario.
Active/Active by definition fails the "passive failover" test, so you have to license the 2 clusters assuming the two instances will be by default running on distinct nodes.
I agree, it is compleltely relevant. You have to pay for additional licenses if you plan on using active/active, as you are only allowed to put databases on the licensed node. You are not required to buy a license for a passive node.
March 24, 2008 at 1:02 pm
george sibbald (3/24/2008)
Matt, Pauls question was could he use standard edition in a two node cluster or would he have to use enterprise edition. The answer is yes he can use standard as there are only two nodes, whether active\active or active\ passive, so the answer is the same whichever set up, hence my use of the term not relevant 🙂
Agreed then - usage doesn't require EE, standard is enough.
----------------------------------------------------------------------------------
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?
March 24, 2008 at 1:09 pm
Matt, thanks. I am sure the extra info on licensing will be useful to david though (don't know where I got paul from, sorry david). If he goes active\active he will save twice as much money on license costs!
---------------------------------------------------------------------
October 18, 2010 at 8:44 am
george sibbald (3/24/2008)
Matt, thanks. I am sure the extra info on licensing will be useful to david though (don't know where I got paul from, sorry david). If he goes active\active he will save twice as much money on license costs!
George did you mean active/passive in the above statement?
October 18, 2010 at 10:23 am
well it's two and a half years ago but I don't think so. I think I meant if he had to buy 2 standard licenses for active\active instead of two enterprise licenses he would be saving twice as much as if he went active\passive and only used one license. 🙂
---------------------------------------------------------------------
October 19, 2010 at 8:39 am
Thanks.
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply