question

RevaneSelimova-0752 avatar image
0 Votes"
RevaneSelimova-0752 asked EricMcWhorter-3627 published

Distributed Availability group between different version of Sql Server

I have configured Distributed Availability Group (DAG) between two WSFC with the same SQL version (sql server 2016),
but now I want to configure the DAG with a different version of SQL Server (SQL Server 2016 and SQL server 2019), but arises error while configuration like 'Cannot open database 'test2' version 852. Upgrade the database to the latest version' and database status is Synchronized/In Recovery and it is mentioned that 'The database 'TEST' is marked RESTORING and is in a state that does not allow recovery to be run.' in SQL logs.
Two different things are mentioned in Microsoft documentation. I mark them in the following picture.
25905-inked25765-microsoftteams-image-7-li.jpg


sql-server-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @RevaneSelimova-0752

Have you arrived at a solution for your issue? We are also experiencing this.

Thanks!

Eric

0 Votes 0 ·
ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered ErlandSommarskog commented

The only time you would have different versions of SQL Server in the same AG is when you are doing a rolling upgrade, and you are upgrading the nodes one at a time.

· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

My question is about Distributed Availability Group which I mean different SQL Server version usage between two AG

0 Votes 0 ·

But that does not change things. It also says in the document that you quote that the reason you would have different versions in a distributed AG is for migration. And, as I understand the text, in AG1 both nodes must be the same version, and the same is true for AG2. Did you do it that way.

Note also, that the second part you highlighted is about Windows Server, which has no relation to the error message you are getting.

0 Votes 0 ·

Yes, in my configuration AG1 is SQL Server 2016 and AG2 is SQL Server 2019. First time I configured each AG with the same Sql version and different WIndows OS for migrating database servers from WIndows 2012 to Windows 2019, it was successfully.
But now I want to upgrade Sql Version at the same time migration from Sql Server 2016 to Sql Server 2019, but secondary AG(forwarder) is not healthy in DAG , database status is SYNCHRONIZED\IN RECOVERY

0 Votes 0 ·
Show more comments
Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered

Hi @RevaneSelimova-0752

According to MS document, the mix major versions of SQL Server in the same distributed availability group is only supported in upgrading and migrating scenarios.

Upgrade distributed Availability Group is different from traditional AG. To perform a rolling upgrade of a distributed availability group, first upgrade all of the secondary replicas. Next, failover the forwarder, and upgrade the last remaining instance of the second availability group. Once all other replicas have been upgraded, failover the global primary, and upgrade the last remaining instance of the first availability group. Please refer to General steps to upgrade a distributed availability group to get more information.

Best regards,
Cathy


If the response is helpful, please click "Accept Answer" and upvote it.
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.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.