installing sql server 2008 r2 in a cluster

Posted on 2012-09-07
Last Modified: 2012-10-15
I have a couple of questions about installing SQL Server 2008 R2 Standard in a 2 node active\passive cluster

First, a little background. The Admin guys have not Clustered Windows yet. The hardware is due in next week so I'm just trying to get my notes together for the SQL install once the Cluster is available.

From what I'm reading, Failover clustering setup has a whole new work flow in SQL Server 2008.

These are the (very high level) steps as a see them to be:

- Run setup on the Active Node of the Cluster using the New Server Server Failover Cluster option
- Failover the resources and run set on the second (now active) Node using the Add Node to a SQL server Failover Cluster option

Is that correct?

Also, I'm not clear about how you would patch the installation and add Instances.

Would you run Service Packs and Cummulative Updates against both nodes? if so, in what order?

In order to add an Instance (I'll be adding 2 Named Instances), What setup option would you use? Would you run set up on the Active Node then failover and run it again to add an Instance?
Also about Named Instances... If I have a simple Active\Passive Cluster with one set of cluster resources and multiple instances, do I need seperate IP addresses for each Instance?

I apologize if the questions seem elementary but this is our first time with SQL Server 2008 and Clustering!

Any help or guidance would be greatly appreciated.
Question by:itsonlyme4
    LVL 22

    Expert Comment

    Microsoft information that answer some questions:

    Author Comment

    Thank you.   that was one of the docs I read that actually prompted my questions.
    LVL 3

    Expert Comment

    Something to keep in mind, you will need 2 host names and IP addresses as you want to install 2 separate instances on the cluster.  The other thing to think about is MSDTC.  You will need 2 separate instances of MSDTC, which will require 2 more hostnames and IP addresses.  (HINT:  You'll probably want to create all Objects in Active Directory and DNS first)

    Secondly, you are correct.  You would create a new clustered node.  After setup finishes, you would go to the secondary node, it doesn't have to be the active node, and add a node to a cluster in sql setup.  What this actually does is not only install SQL, but also goes out to the cluster and gives this node access to the clustered resources.  The clustered resources would be disks, services, SQL hostname/IP, etc....  If you want to have 2 instances, then you would just repeat the process.

    As far as patching, you would patch on the active node, then fail over and patch the other node.



    Author Comment

    Thank you.  That clarifies things a bit.   I thought I had read though that the patching was always done on the 'passive' node first!!??     I can't find anythign definnitive as far as instructions for patching SQL in a the cluster on the Microsoft site.
    LVL 3

    Accepted Solution

    OK, as far as updates go, again, you are correct.

    Installing on an active node can induce downtime.  Therefore, install updates on the passive node.  My appologies.

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Join & Write a Comment

    Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
    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…
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

    728 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

    21 Experts available now in Live!

    Get 1:1 Help Now