How to move the only one instance of sql server from one node to another node in SQL Server Clustering?

Question

Hi,

We have 2 node clustering in my environment. In node-A we have 5 instances. I need to move only one instance from node-A to node-B not complete 5 instances only one. How we will do it. Could you please anyone can share the document regarding this.

Thanks,

Nag.

 

Answer 1

I do not think it is possible, perhaps  you need to add a third node with that instance installed on then move to node B

---

Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Answer 2

Each instance is separate from each other (residing in each own't resource group). Do you mean you want to fail over the instance to B? Then just fail over that instance's resource group to B.

---

Tibor Karaszi, SQL Server MVP | web | blog

Answer 3

Hi TiborK,

              Is it possible fail over only one instance from node-A to node-B. I mean in node-A we have 5 sql instances, into these five instances one instance having more user connections (more than 10,000). So i need to failover this instance from node-A to node-B for load balancing of sql server engine. Is it possible or not. I don't have much knowledge on this. if u have any document or link on this please share me.

Thanks,

Nag.

Answer 4

If you open you cluster failover manager on one of the cluster nodes, or connect to the cluster from somewhere else, flip open the services and applications tree and right-click the instance you want to move. Select "move (...) to another node", and select the other node. This will move the instance.

Note that your users will get disconnected for the time it takes to switch to the other node, though.

You can also move it with powershell ofcourse, but it might be easier for you doing it in the GUI.

Answer 5

Hi,

Thanks you. Its workout.

Thanks,

Nag.

Answer 6

Hi Nag,

Is your cluster set-up Active/Active?

if not, how it is possible to run 4 instances on Node - A and  1 instance on Node -B

Thansk

MK

Answer 7

Hi MK,

Yes It is Active/Active.

Thanks,

Nag.