sqlfriends (5/21/2013)
Can someone help me understand cluster?we have two nodes for the cluster. each cluster we installed two sql instances, one is prod, one is qa.
Does it mean we have total 4 instances installed, or only two instances?
Does the databases located in both of the 4 instances?
Thank
To end up with 4 instances you would need to have 4 lots of resources for the following
disk storage
virtual network name
virtual IP address
clustered sql server service
clustered sql server agent service
You cannot install a clustered and a non clustered instance with the same name into a Windows cluster. So if you had the following
NODEA
NODEB
You have created the windows cluster
SQLCLUSTER01
you install the following clustered instances on NODEA
SQLCLUST01\INST1
SQLCLUST02\INST2
You cannot, on NODEB, create the following stand alone instances
NODEB\INST1
NODEB\INST2
Although you have only run the clustered instance installer on one node, when attempting to install a standalone instance on a node in the same cluster you will receive an error messagebox informing you the instance name is already in use and clustered on node x.
See attached image
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉