Active/passive instance ?
-
If i have an active/passive cluster with sql server 2005 standard edition, can I have more than two instances on the active node to which both could fail over to the passive node if event of failure. We are consolidating some SQL Servers but I would like to isolate one of the instances which has Biztalk databases on it from the other instance.
-
I'm not sure I fully understand your question. You are using SQL Standard in a cluster, which only allows for a 2-node cluster. Are you asking how many instances you can have total or on each node or what exactly. If you could clarify I would be happy to try and help.
CEWII
-
I agree with Elliot. Your question is not completely clear. If your question is if it is possible to have more than two instances in the cluster, then first you must see if the server has enough resources, is that is the case, then the answer is YES. If you will like to run your cluster as an active/active cluster, that is also possible(as long as you have enough resources on both cluster nodes to host all the instances at the same time).
-
Sorry, what I am looking for is that if I have 2 instances of SQl Server on a Standard edition SQL 2005 Active/Passive Cluster, that I expect both instances to fail over to the passive node, will that work with Standard Edition licensing?
-
timscronin (12/7/2009)
Sorry, what I am looking for is that if I have 2 instances of SQl Server on a Standard edition SQL 2005 Active/Passive Cluster, that I expect both instances to fail over to the passive node, will that work with Standard Edition licensing?I think the licensing question is more tied to the number of instances than cluster/non-cluster. Here is the SQL 2005 licensing page from MS..
http://www.microsoft.com/sqlserver/2005/en/us/licensing.aspx
Based on this sentence on the licensing special considerations page:
http://www.microsoft.com/Sqlserver/2005/en/us/special-considerations.aspx
When Licensed per Server/Client Access License. Workgroup, Standard, and Enterprise editions of SQL Server 2005 now allow for unlimited instances within each virtual or physical operating environment. Previously, only the Enterprise Edition of the Server license allowed multi-instancing. This is a great incentive for customers to adopt the Server/Client Access License (CAL) model. For Workgroup and Standard, each virtual or physical operating environment containing a running instance of SQL Server requires a Server license. For Enterprise Edition, each physical operating environment containing a running instance of SQL Server requires a Server license and no separate licenses are needed for SQL Server instances running in virtual operating environments on the same machine.
I think you will be ok, but read for yourself..
As far as both failing over that is a function of your setup, if both SQL Servers exist in the same resource group then a failover of one SQL Server should force both to go.
CEWII
-
timscronin (12/7/2009)
Sorry, what I am looking for is that if I have 2 instances of SQl Server on a Standard edition SQL 2005 Active/Passive Cluster, that I expect both instances to fail over to the passive node, will that work with Standard Edition licensing?Standard Edition allow clustering as you already know. Therefore it is no problem both instance should fail to the pasive none in case of a disaster. However I will advice you to test it during your maintenance window. You want to be sure everything is configure properly and working. As a matter of fact I will advice you to test a failover once a month to be sure everything is working fine.
Good luck
-
Definitely test it! The key to getting them to failover together is they need to be in the same resource group, I don't believe resource groups can be linked for fail-over..
CEWII
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply