Post reply

How the Add node Operation of SQL Server 2008 cluster installation works in 3 node a/p/a setup on Windows 2008

  • February 4, 2011 at 12:57 pm

    #244713

    We have 3 node active/passive/active (a/p/a) cluster setup for SQL Server 2005 on Windows 2003 R2.

    Node1 (Active) has 2 instances.

    Node3 (Active) has 3 instances.

    Node2 is passive. We have configured the cluster in such way that, node1 resources can only failover to node2 and node3 resources can only fail over to Node2

    Now,we want to upgrade Windows 2003 to 2008 and SQL server 2005 to SQL Server 2008 and we need to use the same hardware

    We want to perform the below steps:

    1. Stop all application services and Backup the databases, jobs,logins from all the instances and copy to safe location.

    2. Move node1 resources to node2

    3. Disjoin the Node1 from cluster and install Windows 2008 R2 cluster.

    4. Install SQL Server 2008 R2 ins1(cluster installation) and then restore databases, jobs, logins.

    5. Install SQL Server 2008 R2 ins2(cluster installation) and then restore databases, jobs, logins.

    5. Move the Node3 resources to Node2

    6. Disjoin the Node3 from the cluster and install Windows 2008 R2 cluster.

    7. Install SQL Server 2008 R2 ins3(cluster installation) and then restore databases, jobs, logins.

    8. Install SQL Server 2008 R2 ins4(cluster installation) and then restore databases, jobs, logins.

    9. Install SQL Server 2008 R2 ins5(cluster installation) and then restore databases, jobs, logins.

    10 Join Node1 and Node3. and Disjoin Node2 and install Windows

    Questions:

    Do we need to do the ADD NODE Operation for INS1 and INS2 on Node3 first or install SQL server 2008 instances 3,4,5 first and then perform ADD NODE Operation for Ins1 & Ins2?

    What is the order?

    And Do we need to perform ADD NODE operation for ins3,4,5 on Node1 and 2 also?

    Please advice

    Thanks

  • February 7, 2011 at 10:06 am

    #1283271

    could you please provide your inputs for this cluster upgrade?

    Thanks

  • February 11, 2011 at 1:13 pm

    #1285878

    I'm also in same scenario and confused with the ADD NODE operation on 3 nodes.

    please advice

  • February 15, 2011 at 10:49 am

    #1287200

    Is it possible to configure the SQL Server 2008 R2 cluster on in such way that, node1 resources can only failover to node2 and node3 resources can only fail over to Node2? (The current configuration we have for SQL Server 2005 on Windows 2003 R2 and want to maintain the same configuration.)

    If the above configuration is possible, then do we need perform the ADD NODE Operation on Node3 for the instance installed on Node1?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply