Adding node to SQL 2008 cluster does not require SQL restart.


Adding node to SQL 2008 cluster does not require SQL restart.

Chris Skorlinski
SQL Server Escalation Services

We had this question about SQL 2008 virtual cluster. 

Question:  Is it possible to add node in existing SQL Server 2008 or 2008 R2 Failover cluster instance without downtime (without stopping SQL Server or MSCS services)?
Answer: Absolutely! SQL Server 2008 was designed with rolling installation and upgrades in mind. To confirm:
  1. I built a 2-node Windows 2008 R2 Cluster using Windows 2008 HyperV
  2. I installed SQL 2008 R2 to the 1st node of the cluster
  3. I started a long running SQL transaction
  4. Next I installed SQL to the 2nd node and selected to join the existing virtual SQL Server 2008
The transaction running on the 1st node was never interrupted.

Comments (0)