question

EddyJackson-8342 avatar image
0 Votes"
EddyJackson-8342 asked ElevenYu-MSFT commented

Migration path for Server 2012 (non-R2) SQL Failover Cluster

We have a 2 node SQL Server cluster running on Windows Server 2012 (non-R2). What is the optimal path to migrate the cluster from 2012 (non-R2) to 2016 or 2019? Should we just create 2 new 2016 or 2019 VMs and create a new cluster? Should we create a 2012 R2 VM and create a new cluster and then evict one of the existing nodes and perform an in place upgrade to 2012 R2?

sql-server-generalwindows-server-2012windows-server-clustering
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi,

Do you have any further question?

If the Answer is helpful, please click "Accept Answer" and upvote it. Thanks.

0 Votes 0 ·

Hi,

May I know if your issue is resolved or not?

It will be much appreciated and encouraged if you could click "Accept Answer" and upvote the helpful reply.

Thanks a lot.

0 Votes 0 ·

1 Answer

ElevenYu-MSFT avatar image
1 Vote"
ElevenYu-MSFT answered ElevenYu-MSFT commented

Hi,

There are ways to migrate your Server 2012 SQL failover cluster to 2016 or 2019.

The first one is to migrate it to a new cluster by creating a parallel SQL Server environment on a different Windows Cluster with Windows Server 2016 or 2019. That means, you will need to create 2 new 2016 or 2019 VMs and create a new cluster. The impact is that there will be some downtime.
Please refer to below articles for details.
https://docs.microsoft.com/en-us/sql/sql-server/failover-clusters/windows/upgrade-sql-server-failover-cluster-instance-2008-2012?view=sql-server-ver15#scenario-2-windows-clusters-with-sql-server-failover-cluster-instances-fcis

The second one is to do in-place migration to Server 2012 R2 first and then do rolling upgrade to 2016 or 2019.
Please read below articles for detailed steps.
In-Place Migration for a Two-Node Cluster: Migration to Windows Server 2012 R2
Cluster operating system rolling upgrade



Thanks,


If the Answer is helpful, please click "Accept Answer" and upvote it. Thanks.

· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

So, if we want to avoid downtime, we would need to evict the inactive Server 2012 node and do an in-place upgrade of the node to 2012 R2? And essentially hope that the active node doesn't have any service disruptions during either upgrade? Wouldn't it make sense to also setup a 3rd 2012 R2 node to join the cluster during the upgrade process?

0 Votes 0 ·

Hi,

we would need to evict the inactive Server 2012 node and do an in-place upgrade of the node to 2012 R2

Yes

And essentially hope that the active node doesn't have any service disruptions during either upgrade?

First node is evicted from the old cluster, the second node in the old cluster will provide service normally. But high availability is lost since there is only one node working.
After the cluster role is migrated to the new cluster with the first node, which has been upgraded to 2012 r2, and you bring the role online on the new cluster, this first node will provide service in the new cluster. Still high availability will be lost during the upgrade for the second node.

Wouldn't it make sense to also setup a 3rd 2012 R2 node to join the cluster during the upgrade process?

I think 2012 and 2012 R2 cannot be compatible in the same cluster. So, if you add the 3rd 2012 r2 node to the new cluster after the first node is upgraded and cluster roles has been migrated and online, it seems you do not need to upgrade the second node in the old cluster since you already had a new 2012 r2 node added to the new cluster.

Thanks,
1 Vote 1 ·

Hi,

May I know if you have any further question?

If no, could you please help to click "Accept Answer" so that others could find the solution to similar questions quickly?

0 Votes 0 ·