SQL Server Performance Forum – Threads Archive
Add a New Nodes in a Existing ClusterHi,<br /><br /> I have two Servers with 3 SQL Server Instances. How could I add a new server in the SQL cluster without adding a new instance? So, I have 3 servers to hold 3 instances each other by failover?<br /><br />Thx for your suggestion!<br />thx[<img src=’/community/emoticons/emotion-1.gif’ alt=’‘ />][<img src=’/community/emoticons/emotion-1.gif’ alt=’‘ />]<br /><br /><br />
For Windows 2003:
Could I add a new node in SQL Cluster by SQL setup without adding a new instance? Thx
Yes. From BOL:
Adding a Node to an Existing Virtual Server
During SQL Server Setup, you are given the option of maintaining an existing virtual server. If you choose this option, you can add other nodes to your failover cluster configuration at a later time. You can add up to three additional nodes to an existing virtual server configured to run on one node. How to add nodes to an existing virtual server (Setup) On the Welcome screen of the Microsoft SQL Server Installation Wizard, click Next. On the Computer Name screen, click Virtual Server and specify the virtual server to which you want to add a node. Click Next. On the Installation Selection screen, click Advanced options. Click Next. On the Advanced Options screen, click Maintain a virtual server for failover clustering. Click Next. On the Failover Clustering screen, click Next.
You do not need to enter an IP address. On the Cluster Management screen, select the node and click Add.
If the node is listed as unavailable, you must modify the disk resources in the cluster group of the virtual server so the disk is available for the node you want to add to the MicrosoftÂ® SQL Serverâ„¢ configuration. Click Next. On the Remote Information screen, enter login credentials for the remote cluster node that has administrator privileges on the remote node of the cluster. Click Next. On the Setup Complete screen, click Finish.