[Last Call] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 550
  • Last Modified:

SQL Clustering

SQL Experts,

I am setting up a Database environment with SQL server 2008 with two nodes in the cluster. Due to hardware reasons, I would like to set up a cluster with 1 node initially and when the second server is available I want to add it to the cluster. There are concerns in my team that adding a second node later requires lot of re-configurations, might be many complications, bla bla bla. So, I have the following questions for the experts, please help me out here..Thanks for your answers.

1. Is it possible to set up a cluster with 1 node?
2. How easy it is to add a second node to the cluster?
3. Will there be any downtime or performance issues, complications in adding second node at a later stage?
2 Solutions
x-menIT super heroCommented:
1. yes
1. As easy as selecting "Add node to a SQL failover cluster installation" at the SQL Server Instalation Center.
Scott PletcherSenior DBACommented:
Agree with x-men.

On #3, naturally you must have compatible hardware that qualifies for clustering with node 1.  Other than that, you should have no issues.

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Tackle projects and never again get stuck behind a technical roadblock.
Join Now