63,630 pts.
POSTED: May 14, 2008 7:46 AM (GMT)
Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.
How to install a passive node on an active/active SQL Server cluster
We have a SQL cluster server running with SQL Server 2005 Enterprise Edition SP2 on Windows 2003 Enterprise Edition. Currently the cluster has 2 nodes with Active/Active. Now I need to add a new node as a Passive node. So once I’m done, the cluster will be a Active/Active/Passive cluster.
Because the cluster is a production server, I need to know exactly how I can add a new node onto the current cluster without breaking anything. Also this is my first time installing a passive node, so it is difficult for me to understand how to install and configure it.
Because the cluster is a production server, I need to know exactly how I can add a new node onto the current cluster without breaking anything. Also this is my first time installing a passive node, so it is difficult for me to understand how to install and configure it.
ASKED:
May 14, 2008 3:09 AM GMT
UPDATED:
May 14, 2008 7:46:35 AM GMT
RELATED QUESTIONS
- SQL 2005 Active/Active/Passive
- SQL Server 2005 multi-instance cluster
- moving an existing active/passive 2005 SQL cluster onto an existing active/active SQL 2008 cluster.
- Can I add a local SQL 2005 instance to a clustered node
- Add an Active node to SQL Server Active Passive Cluster
- SQL Server active/active node clustering
- Setting up an Active-Active IIS Cluster with ARR
- Creating second instance on SQL Server 2008 cluster
- cluster install node failure when adding
- Exchange Migration
Answer Wiki:
First you need to add another node into the Windows cluster. This is done with the Cluster Administrator. Run through the wizard to add the machine into the cluster. Your Windows admin can probably do this for you.
After the machine is part of the cluster, run through the SQL installer again and it will give you the option to push the service to the new machine in the cluster. You will need to do this twice, one for each instance. After then you'll need to patch both instances again to the same patch level you are on currently.
After the machine is part of the cluster, run through the SQL installer again and it will give you the option to push the service to the new machine in the cluster. You will need to do this twice, one for each instance. After then you'll need to patch both instances again to the same patch level you are on currently.
To see other answers submitted to the Answer Wiki View Answer History.
