SQL Server Performance

Add a New Nodes in a Existing Cluster

Discussion in 'SQL Server Clustering' started by kevinngcc, Dec 22, 2005.

  1. kevinngcc New Member

    Hi,<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 />
  2. Argyle New Member

  3. kevinngcc New Member

    Could I add a new node in SQL Cluster by SQL setup without adding a new instance?

  4. Argyle New Member

    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.

Share This Page