December 4, 2012 at 9:28 am
We have a cluster named Cluster1 which is a single node cluster. It has SQL Server 2008R2 Enterprise edition installed on it.
And we have another cluster Cluster2 which is also a single node cluster. It has SQL Server 2012 installed on it.
The node present in Cluster1 is Node1
The node present in Cluster2 is Node2
We are trying to do the following:
1. Upgrade SQL 2008R2 to SQL 2012 which is in Cluster1
2. Then remove Node2 from Cluster2 and add that Node as a second node in Cluster1, to make Cluster1 as two node Active-Passive cluster
What's the best way of doing this? Thanks
December 4, 2012 at 2:37 pm
What do you want to happen with the 2012 instance in cluster 2?
If I read this correctly, you have 2 clusters and you want to combine the nodes into a single cluster instead. If that is the case, then you need to install a new instance on cluster 1 running 2012. Move the databases from the instance on cluster 2 to the new instance on cluster 1 - validate the new instance is working as expected and migrate the applications/users to the new instance.
Once that is done, shut down the old instance - uninstall it from cluster 2. Remove clustering from the cluster 2 node - or, preferably nuke & pave the server so it matches node 1. Once that is done, add the node to the cluster and validate the cluster.
Once you have a validated 2 node cluster, then you can go through the process of adding SQL Server to the new node for each instance.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 5, 2012 at 2:00 am
Mh-397891 (12/4/2012)
We have a cluster named Cluster1 which is a single node cluster. It has SQL Server 2008R2 Enterprise edition installed on it.And we have another cluster Cluster2 which is also a single node cluster. It has SQL Server 2012 installed on it.
The node present in Cluster1 is Node1
The node present in Cluster2 is Node2
We are trying to do the following:
1. Upgrade SQL 2008R2 to SQL 2012 which is in Cluster1
2. Then remove Node2 from Cluster2 and add that Node as a second node in Cluster1, to make Cluster1 as two node Active-Passive cluster
What's the best way of doing this? Thanks
It's not difficult, just a fair amount of work.
Do you need the SQL 2012 instance on Cluster2\Node2?
A more viable option may be to migrate all the databases in the SQL2008 R2 instance on cluster1 to the SQL 2012 instance on cluster 2 and then destroy the cluster on Node1.
Once this is done rebuild the Node1 OS completely to match Node2 and then introduce the new node into the cluster2.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 5, 2012 at 3:44 am
Thanks for the responses.
I will be doing the following steps, please let me know if I am missing anything in here:
1. Remove the SQL 2008R2 from Cluster1\Node1
2. Install SQL 2012 in Cluster1\Node1 along with SP1
3. Stop the SQL Server in Cluster2\Node2
4. Remove the SAN drives from the SQL Server
5. Add those SAN drives to Cluster1\Node1
6. Bring all the databases online in Cluster1\Node1 which has SQL 2012
7. Validate it and migrate all the applications and users to the new instance
8. On Cluster2\Node2 - Run Cluster /destroy --To destroy the Cluster2
9. On Cluster2 - Run Cluster /Force -- This removes the node from the cluster
10. Then add that Node2 which was removed from Cluster2, into Cluster1 and do a fresh install of SQL 2012 while adding that as a new node in Cluster1.
11. Install SQL 2012 SP1 on Node2.
Thanks a lot.
December 5, 2012 at 4:38 am
Mh-397891 (12/5/2012)
1. Remove the SQL 2008R2 from Cluster1\Node1
You don't need to retain any databases from here then??
Mh-397891 (12/5/2012)
2. Install SQL 2012 in Cluster1\Node1 along with SP1
Why when you already have a running instance on the second cluster??
Mh-397891 (12/5/2012)
5. Add those SAN drives to Cluster1\Node1[/code]
I assume you're planning to just swap the drives across? What SQL Server configuration data do these SAN drives contain?
Mh-397891 (12/5/2012)
8. On Cluster2\Node2 - Run Cluster /destroy --To destroy the Cluster29. On Cluster2 - Run Cluster /Force -- This removes the node from the cluster
If you destroy the cluster why do you think that you then need to force remove the node?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply