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

Share this Post

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.

Share this Post

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.