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

x
  • 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?
0
BoozTech
Asked:
BoozTech
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.
3.no
0
 
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.
0

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