Migrate from SQL Server 2014 Failover Cluster to 2019 Availability Group and rollback plan

Cristian Mitan 21 Reputation points
2021-03-18T15:49:15.163+00:00

Hi,
we have a 2 node SQL Server 2014 failover cluster with 2 SQL Server instances and about 100 databases to be migrated to an availability Group 2019. What is the faster way to do that considering that we have one weekend for any instance? What's the best rollback strategy considering that restore from a recent version to an older one is not possible? Any idea?

thanks

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
515 questions
0 comments No comments
{count} votes

Accepted answer
  1. CathyJi-MSFT 21,126 Reputation points Microsoft Vendor
    2021-03-19T06:40:49.633+00:00

    Hi @Cristian Mitan ,

    > we have a 2 node SQL Server 2014 failover cluster with 2 SQL Server instances and about 100 databases to be migrated to an availability Group 2019.

    What did you real mean? SQL server 2014 failover cluster instance is a instance level HA. SQL server 2019 availability group is a database level HA. They are different. Please refer to the blog Always on Availability Groups vs Always on Failover Cluster Instances to get more information.

    Or if you have SQL server 2014 AG and want to upgrade AG replica instance from SQL 2014 to SQL2019? Suggest you rolling upgrade for AG replica instance. Refer to Rolling Upgrade Process to get detail steps.

    Or if your AG contains failover cluster instance (FCI) nodes, you should upgrade the inactive nodes before you upgrade the active nodes. Refer to AG with Failover Cluster Instance Nodes to get detail upgradation steps.

    If I misunderstood your question, please let me know. And please describe your question more clearly to make us better understood this question .


    If the response is helpful, please click "Accept Answer" and upvote it, thank you.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


0 additional answers

Sort by: Most helpful