Adding a secons instance to a SQL 2008 R2 cluster

Posted on 2011-11-01
Last Modified: 2012-05-12

I want to add another instance to my SQL cluster but how does it work?
Do I have create another quorum disk, msdtc disk, system database disk and user database disk?


Question by:cdron
    LVL 39

    Expert Comment

    I don't have experience in doing this, so hopefully someone else will come along and give their input.  But I would assume that if you want the instances to move from node to node together, then they can be installed in one clustered resource pool and therefore a second quorum disk would not be required.
    LVL 22

    Expert Comment

    As stated above 2nd quorum disk not required.

    A second instance would require a new group (resources: network name and IP) and disks for the SQL data.
    his configuration would allow for "active active" clustering.
    LVL 22

    Accepted Solution


    Author Closing Comment

    Thank you!

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    755 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

    16 Experts available now in Live!

    Get 1:1 Help Now