Saturday, November 24, 2012 12:20 PMHow to fail-over only one instance in clustering? If we having multiple instance in Active/Passive Cluster?
Saturday, November 24, 2012 5:10 PM
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.
- Proposed As Answer by Kumar muppa Sunday, November 25, 2012 1:49 AM
Saturday, November 24, 2012 6:31 PMAnswerer
Sunday, November 25, 2012 1:55 AM
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.
Sunday, November 25, 2012 3:52 AM
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.
- Edited by S.Vijay Kumar Sunday, November 25, 2012 3:54 AM Typo
Sunday, November 25, 2012 4:22 AMAnswerer
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.
- Marked As Answer by S.Vijay Kumar Sunday, November 25, 2012 2:32 PM