Forum Discussion

Martins_Aded515's avatar
Martins_Aded515
Copper Contributor
Feb 13, 2024

Migration using Always On Availability Group between different Servers (2016 To 2019) Issues.

Hello, I am new here, I have a SQL Server 2016 with Four servers and they are part of a cluster, I am trying to migrate all the databases in the Primary replica to a new server. I have provisioned two 2019 servers one will be my New Primary replica and the second to be my secondary server.

I have added these two new servers into the Availability replicas (Part of the cluster now) On one node in the new servers after adding it, I always get this " Database is not synchronizing & Data Loss " Even after removing the servers many times to readd again, I will get this error, also when I tried to access the database, I will always get database not accessible on both Servers. Is the best method to do the migration? why is there anyway the database can be accessible? 

Thank you.

No RepliesBe the first to reply

Resources