Move Instance from One Node to the Other

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

High Availability (2005)

Move Instance from One Node to the Other

Author

Topic

LOOKUP_BI
Constraint Violating Yak Guru

295 Posts

Posted - 2011-06-15 : 11:46:15

Im pretty new to clustering and have been asked to move an instance from one node to the other.

Currently this is the setup that we have,

Our Cluster has 2 nodes
Node 1 - Has 3 instance
Node 2 - Has 1 instance

So how do I move the instance in Node 2 to Node 1 ?

SQL Server 2005 EE

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-06-15 : 11:58:19

You just do a failover inside Cluster Administrator (Windows 2003) or Failover Cluster Management (Windows 2008). If you don't know how to do this, then I would suggest contacting your server administrator to help you with this.

Also, you need to ensure that the memory is setup properly on all 4 instances so that you don't have a memory problem when running on one node. It is generally recommended that on clusters you have no more than one instance running on each node, but the ever better practice is to only have one instance for the entire cluster (but that's generally not followed as it's considered a waste of hardware resources).

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog