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

Eddy 1 Reputation point
2021-07-06T18:44:56.26+00:00

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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,583 questions
Windows Server 2012
Windows Server 2012
A Microsoft server operating system that supports enterprise-level management, data storage, applications, and communications.
1,524 questions
Windows Server Clustering
Windows Server Clustering
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Clustering: The grouping of multiple servers in a way that allows them to appear to be a single unit to client computers on a network. Clustering is a means of increasing network capacity, providing live backup in case one of the servers fails, and improving data security.
953 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Eleven Yu (Shanghai Wicresoft Co,.Ltd.) 10,671 Reputation points Microsoft Vendor
    2021-07-07T05:27:13.713+00:00

    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://learn.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.

    1 person found this answer helpful.