SQL Server Performance

Add New Node in SQL Server 2005

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

  1. kevinngcc New Member

    I want to setup a 3 nodes with 4 instances SQL Cluster. However, after finishing the SQL Cluster, if I want to add a new SQL server in the cluster, how could I install a SQL server in my new server without adding new instance. Then, I could failover to have 4 nodes with 4 instances.<br /><br />Thx for your help!!!<br /><br />Thx[<img src='/community/emoticons/emotion-2.gif' alt=':D' />][<img src='/community/emoticons/emotion-2.gif' alt=':D' />]
  2. simondm New Member

    Add the node to the windows cluster as normal. Then run the SQL Setup program on the new node - you will be given the option to add a new node to the virtual server/instance.
  3. kevinngcc New Member

    Thx for your help!

    However, when I add a new node to the virtual server in the cluster by SQL setup, I must also create a new instance. How could I add a new node without adding a new instance?

    thx
  4. mulhall New Member

    quote:Originally posted by kevinngcc

    Thx for your help!

    However, when I add a new node to the virtual server in the cluster by SQL setup, I must also create a new instance. How could I add a new node without adding a new instance?

    thx

    Hi there,

    You're confusing SQL Server Instances with Cluster nodes.

    A node is a Windows Server installation, you add servers through Cluster manager on your cluster.

    An SQL Server instance is an installation of SQL Server.

    To move from a 3-node cluster to a 4-node cluster you need to get another machine, install windows server and add it to the cluster.
  5. biged123456 New Member

    I think there may be more to this question. It is not difficult to add the new node to the windows cluster, but is there anything you need to do to the node to allow the existing SQL instances to failover to it? I think this may be the way -http://msdn2.microsoft.com/en-us/library/ms191545(en-US,SQL.90).aspx - also listed in books online as Add or Remove Nodes in a SQL Server 2005 Failover Cluster (Setup). I haven't tried this yet, but am working on getting test cluster equiptment to give it a go...

Share This Page