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.
Questions tagged [distributed-availability-groups]
42 questions
22
votes
3 answers
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 month, I upgraded a remote secondary server from…
Taryn
- 9,466
- 3
- 41
- 74
11
votes
2 answers
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 the secondary database into the AG on the…
Alf47
- 931
- 1
- 8
- 21
5
votes
2 answers
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 (primary) and AG2 (secondary)
We
Joined Clus02…
DJSQL
- 53
- 1
- 3
5
votes
2 answers
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 without any issues, however when we then moved on…
Greg Bray
- 983
- 3
- 11
- 20
4
votes
1 answer
Distributed AG on SQL Server 2017 Standard Edition?
Can I configure Distributed AG with SQL Server 2017 Standard Edition?
Luis Agustin Azario
- 43
- 3
4
votes
1 answer
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 join to the 2016 AG.
This is a 0 downtime…
Blablas
- 43
- 4
3
votes
2 answers
MS SQL 2017 cluster: impact of disabling distributed transactions for an availability group
A company is having a Microsoft SQL Server 2017 Enterprise cluster (RTM-GDR, 64-bit, 14.0.2027.2, KB4505224) consisting of one Availability Group (AG) with two servers, a primary and a secondary.
A closed source application used by this company…
Arthur Borsboom
- 133
- 3
3
votes
2 answers
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 availability group.
The way I managed execution of jobs…
Marcello Miorelli
- 14,544
- 46
- 126
- 249
3
votes
2 answers
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 ([AG 2, AG…
Marksl
- 175
- 5
2
votes
1 answer
Remove database from Distributed Availability Group replica AG ONLY!
all!
I have an existing always on availability group on-prem and last week created a second one in AWS. After that, I created a distributed availability group with on-prem as primary and AWS as the replica AG.
Being new to SQL Server, I configured…
calmkza
- 21
- 1
2
votes
1 answer
Upgrade with DistributedAG vs adding a node with SQL Server 2019
We would like to migrate from SQL Server 2016 to SQL Server 2019. The databases are part of an Availability Group.
I added a new replica using SQL Server 2019 on a new node and made that replica part of the AG and then failed over successfully to…
kevin
- 73
- 6
2
votes
0 answers
Problems with Distributed Availability Group( DAG)
I have 2 servers in AWS Central joined with AWSCentralAG and I have 2 servers in AWS West joined with AWSWestAG. Obviously, I have the listener name and listener IP address and I able to connect to each other both ways without any problem. Now, I…
Sid
- 175
- 1
- 6
2
votes
0 answers
Distributed Availability Group Endpoint_URL Setup Question
I have two sites: SiteA and SiteB. Both sites are running SQL Server 2017 Enterprise v14.0.3048.4 on Windows 2012. Both sites are linked with a dedicated VPN connection. We have a series of availability groups created: AG1-9 at each site with the…
Alf47
- 931
- 1
- 8
- 21
2
votes
0 answers
Multiple Location AlwaysOn and Azure SQL Server
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 will have user-defined datatypes which are not…
Trent Adams
- 21
- 1
2
votes
1 answer
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 "Cancelling" status. So I restarted the SQL Service to…
GoldenDBA
- 31
- 2