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

Eddy 1 Reputation point

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


    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.

    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



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

    1 person found this answer helpful.