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

Question

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

Answer 1

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.