Adding third node to Windows 2008 SQL failover cluster

Posted on 2012-09-14
Last Modified: 2012-09-14
I'm planning to add a third node to a two-node Windows 2008 R2 SQL 2008 R2 failover cluster. Does adding this third node to the cluster and then installing SQL on the third node cause the cluster to go offline for any period of time? (I've already run all the cluster validation tests for the new node, including storage, I just haven't added the node yet.)
Question by:ckratsch
    LVL 7

    Accepted Solution


    Adding a 3rd node does not cause the other 2 nodes to go offline.  If you have a 'preferred node' you can set that up but there's no risk in not doing so.
    LVL 14

    Author Closing Comment

    Thanks - that's what I thought, but I wanted to get some confirmation on it.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
    You might have come across a situation when you have Exchange 2013 server in two different sites (Production and DR). After adding the Database copy in ECP console it displays Database copy status unknown for the DR exchange server. Issue is strange…
    This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…
    This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now