Migrate from SQL Server 2014 Failover Cluster to 2019 Availability Group, rollback plan 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 a older one is not possible?
Any idea?
thanks
2 Massive questions
You haven't said anything about what is connecting to your databases.
For swapping over the databases log shipping will give you a much shorter cutover time than backup &amp; restore.
If you can add a AOAG Listener with the name of the old server you will simplify updating all of the client connection strings (means the old server has to be powered down or renamed).
For rollback one generally has as thorough acceptance testing as possible - if that fails just power down the new server and power up the old one. Once clients are connecting and adding new data you have gone past the point of no return &amp; know you have to fix any problems that occur on the new server.