Active/Passive Cluster

Question

How to fail-over only one instance in clustering? If we having multiple instance in Active/Passive Cluster?

Answer 1

Hi Vijay,

For every sql server clustered instance, there will a separate resource group in cluster administrator.

If you need to failover only one instance, right click on the respective resource group and select move group.

Regards,

Mohammed

Answer 2

Ramesh,

This is not actually correct. A failover can move 1 or more instances to other nodes, depending on the type of failover, what caused it, and what resource groups it affects.

-Sean

---

Sean Gallardy | Blog | Twitter

Answer 3

vijay,

say you have node1 nad node2 installed SQL fail over cluster.

now instance on node2 is running now you want to start fail over instance on node1 !!!!! is it what you looking for?

Then answer is: open your cluster manager and navigate to nodes then choose the node2 right click then you find the options to fail over the resources.

good luck.

kumar

Answer 4

Hi Kumar,

Let me explain.

I having Node1 and Node2. Node1 contains some 4 Instances. Now i want to fail-over only once instance to Node B.

Answer 5

Vijay,

Kumar is correct, you'll need to open up cluster manager and connect to that cluster (if using remote management). Once connected, find the resource group you want to move that contains the instance of SQL Server you're looking for. Depending on your version of windows, you'll want to right-click and choose move then choose a possible owner to move the group to.

-Sean

---

Sean Gallardy | Blog | Twitter