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.

Filter by
Sorted by
Tagged with
0
votes
0answers
42 views

Help with set up replication distribution database in Always On availability group

After following official microsoft guide and sample walkthrough: https://docs.microsoft.com/en-us/sql/relational-databases/replication/configure-distribution-availability-group?view=sql-server-2017 ...
0
votes
1answer
26 views

SQL Server Distributed Availability Group Usage Pattern

I have got a client with DAG setup on 2016 & 2017 servers. I understand that their usage is most likely for DR purposes. What I'm a little unclear on (and I can't find any info on it) is how they ...
4
votes
1answer
108 views

Distributed AG on SQL Server 2017 Standard Edition?

Can I configure Distributed AG with SQL Server 2017 Standard Edition?
0
votes
1answer
34 views

Adding ReadOnly Domain-less replica to existing AG with two replicas on two nodes WSFC

I have AG setup as follows: Multi sub-net WSFC (Windows Server 2016) - All nodes part of same domain AG with two replicas (SQL 2017) - Each node (mentioned above) contains one standalone instance. ...
2
votes
0answers
84 views

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 ...
1
vote
1answer
833 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 ...
2
votes
0answers
26 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 ...
0
votes
1answer
269 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
235 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....
3
votes
2answers
124 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 ...
4
votes
1answer
795 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 ...
0
votes
1answer
58 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 "...
1
vote
1answer
126 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 ...
7
votes
2answers
1k 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 ...
2
votes
1answer
936 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
384 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 ([...
1
vote
1answer
211 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 -...
0
votes
1answer
111 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 ...
22
votes
3answers
4k 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 ...
4
votes
2answers
4k 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 (...
1
vote
1answer
427 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 ...
5
votes
2answers
2k 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 ...