Questions tagged [distributed-availability-groups]

A variation of the existing AOAG feature that connect AGs in two or more clusters. Distributed Availability Groups are a new feature in SQL Server 2016.

22
votes
3answers
3k views

SQL Server Distributed Availability Group databases not syncing after a server reboot

We're getting ready to perform a large upgrade on our SQL Servers and are noticing some unusual behavior with Distributed Availability Groups that I'm trying to resolve before moving forward. Last ...
6
votes
2answers
769 views

Distributed Availability Group with Manual Seeding

I am looking for a step by step walk through of how to setup a distributed availability group with manual seeding. I can get the automatic seeding working but when I try to manually seed I cannot get ...
5
votes
2answers
1k views

Distributed Availability Group Direct Seeding FAILED, failure_state SQL Error, failure_state 2

We just started setting up Distributed Availability groups to replicate our production databases into a new reporting cluster. The first availability group that we setup for replication worked great ...
3
votes
1answer
472 views

Mixing SQL Server 2016 and 2017 in a distributed availability group

I have an old Availability Group made up of 2 SQLServer 2016 instances (2 Windows 2016 servers in WSFC) I also have 2 new SQLServer 2017 instances (2 Windows Server 2016) that I originally wanted to ...
3
votes
2answers
72 views

function to check whether the current server is involved in an availability group and if so, whether it is the primary

I used to have 2 servers on an availability group, but there was a problem with one of them servers involved,while patching, and to make a long story short I removed all the databases from the ...
3
votes
2answers
2k views

Cannot remove Database from Distributed AlwaysOn Group on Secondary Windows Cluster

We have Distributed AG across two windows clusters. Clus01 - Has an AG set up with no DB inside it (AG1) Clus02 - Has an AG set up with no DB inside it (AG2) Clus01 - Has a DistAG set up with AG1 (...
2
votes
1answer
488 views

List primary replicas and non-HA databases - excluding forwarder replicas

When asking which databases are writable on any given server, I've been using the below snippet to list PRIMARY replica databases and databases that do not participate in an AG. Now that I've ...
2
votes
1answer
270 views

SQL Server - Is there a limit to the number of Distributed Availability Groups that a primary replica can participate in?

The documentation has diagrams with availability groups taking part in multiple Distributed Availability Groups (AG 1, AG 2 and AG 3) take part in Distibuted AG1 ([AG 1, AG 2]) and Distributed AG2 ([...
2
votes
0answers
18 views

Multiple Location AlwaysOn and Azure SQL Server [closed]

AS with the majority of projects, the original scope may not be a viable option. We were using Azure Data Sync and transaction replication to keep the 4 site databases in sync. However, the customer ...
1
vote
1answer
95 views

Difference between High Availability data synchronization across local replicas and DAG

I see a significant difference when synchronizing data between Primary - Secondary and between Primary HA and Secondary HA as part of Distributed Availability Groups. The difference in the amount of ...
1
vote
1answer
74 views

Always On Availability Question mark

In my production environment I have two database Servers know as DBN1 and DBN2. I have made a cluster between two and DBN1 is my primary database server. Now I used Always on availability feature on ...
1
vote
0answers
143 views

Configuring Availability group between Two SQL Server Failover Cluster Instances

I am having two Windows clusters. Two SQL cluster instances are there in each two node cluster ( Data centre 1 :Windows Cluster 1-SQL2016CLUS1 Node 1 Node 2 SQL 2016 failover cluster instance1 -...
1
vote
0answers
330 views

Distributed Availability Group Failover Issue

I have created Distributed Availability group set up as below: In Data center A, created 2 node AG1 setup (Synchronous) in Datacenter B, created 2 node AG2 setup (asynchronous). Created Distributed ...
0
votes
1answer
64 views

Error in AG Dashboard when looking at a Distributed AG

I have a Distributed AG, but whenever I go to look at the AG Dashboard it says "An error occurred on the Always On Dashboard". When I click for details I get "Object reference not set to an instance ...
0
votes
1answer
47 views

Network Packet Payload Error when Trying to Create Distributed Availability Group

I am attempting to create a distributed AG on SQL 2016 SP1, but keep getting the following errors. I have tried this in a VirtualBox (local desktop) and actual VMWare virtual environment but getting ...
0
votes
1answer
53 views

Get DAG members

Via transact SQL with this query: SELECT ag.[name] as 'AG Name', ag.Is_Distributed, ar.replica_server_name as 'Replica Name' FROM sys.availability_groups ag, sys....
0
votes
1answer
27 views

Orphaned Availability Group Name

So I was creating a distributed availability group and noticed I wanted to change the name of the AG so I tried to run DROP AVAILABILITY GROUP. But it was already seeding and was just stuck in "...