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
1 answer
67 views

SQL Server Distributed Availability Group databases not syncing after a Global Primary Replica Failover

SQL Server Distributed Availability Group Environment AG1 => Node1 (AG1-Global Primary) and Node2 (AG1 - Secondary Replica) AG2 => Node3 (AG2-Forwarder) and Node4 (AG2 - Secondary Replica) DAGE ...
user avatar
0 votes
1 answer
55 views

Can Availability Group be configured in a below structure?

I have Production and DR clusters as depicted on a picture below. My question is whether there is a way to configure Availability Group from datacenter1 to datacenter2? I tried to configure regular ...
user avatar
  • 637
1 vote
1 answer
43 views

Is Log stream compression enabled by default for asynchronous replicas in Distributed Availability groups as well?

I am seeding a database using distributed availability group. Seeding is automatic but synchronization mode is asynchronous. Log stream compression for automatic seeding is NOT enabled via TF 9567. ...
user avatar
2 votes
1 answer
211 views

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 ...
user avatar
  • 21
0 votes
1 answer
71 views

Failover and Failback SQL server Distributed availability group with different versions

I know that SQL server Distributed availability groups can sync data between two different Major versions, Lets say Global Primary - 2016 Secondary AG - 2017 This sync will work and I can do failover ...
user avatar
  • 1,688
0 votes
2 answers
34 views

SQL server 2017 distributed availability group connectivity after failover

I'm going to deploy SQL server distributed availability groups with SQL server 2017. From the documentation, I understand that we can have listeners for primary AG and secondary AG. The application ...
user avatar
  • 1,688
1 vote
1 answer
123 views

How to Reconnect Apps to a Different Listener in a SQL Server Distributed Availability Group

I have created a SQL Server Distributed Availability Group (AG), which spans two underlying AGs, each of them deployed on a Windows Cluster at a different location. I have also created a Listener for ...
user avatar
  • 163
0 votes
0 answers
41 views

Failing Over on the Fisrt SQL Server AG at one Location breaks the Distributed AG at the Second Location

I have configured a SQL Server Distributed Availability Group (AG), containing a Windows cluster with an AG at one location, and a second cluster with its own AG at another location (thus, two AGs). ...
user avatar
  • 163
0 votes
1 answer
48 views

SQL Server Installation for a Distributed Availability Group

I am deploying a SQL Server 2019 Distributed Availability Group. I have created a WSFC at each of my two sites (spanning two servers each). Upon installing SQL Server, it is not clear to me if I ...
user avatar
  • 163
0 votes
1 answer
42 views

Are Quorums necessary in a SQL Server Distributed Availability Group

I am creating a SQL Server 2016/2019 Distributed Availability Group, which will host 2 AGs (one at one location and another at a different location). Do I need to create a Quorum for each of the 2 ...
user avatar
  • 163
1 vote
1 answer
132 views

LISTENER_IP = ALL not working

I try to create an endpoint specifying to listen on any IP: CREATE ENDPOINT [Hadr_endpoint] AS TCP ( LISTENER_PORT = 5022, LISTENER_IP = ALL ) FOR DATABASE_MIRRORING ( ...
user avatar
3 votes
2 answers
188 views

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 ...
user avatar
1 vote
1 answer
44 views

Sync logins and Agent jobs across all replicas in Distributed Availability Group

I am using dba_CopyLogins stored proc to sync logins on replicas in Distributed Availability groups, but the database level permissions are not transferred due to database sync operation is going on.. ...
user avatar
  • 11
-1 votes
1 answer
803 views

How to find the distribution of star ratings to the business in the following cities? (SQLITE) [closed]

select stars from business where city = 'Avon'; Data: +-------+ | stars | +-------+ | 2.5 | | 4.0 | | 5.0 | | 3.5 | | 1.5 | | 3.5 | | 4.5 | | 3.5 | | 2.5 | | 4.0 | +-------+ ...
user avatar
2 votes
1 answer
119 views

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 ...
user avatar
  • 73
2 votes
0 answers
129 views

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 ...
user avatar
  • 175
0 votes
2 answers
793 views

Distributed Availability Group between SQL Server 2016 and SQL Server 2019 doesn't seed

Appologies for a long first post :-) I'm planning on implementing a distributed availability group between an existing SQL2016 AG and a new SQL Server 2019 AG, and am validating the design in a LAB ...
user avatar
  • 1
0 votes
1 answer
92 views

Why distributed AG is preferred to normal AG for cross datacenter failover scenario?

I have two node WSFC and currently I'm working on DR solution with availability group.I already read microsoft doc about distributed AG.So my question is what are benefits of using distributed AG ...
user avatar
  • 11
1 vote
2 answers
1k views

Single node availability group - is it possible?

Is it possible to have an availability group with just one node in it? The reason I ask is because I am considering a distributed availability group spanning two single node always on availability ...
user avatar
0 votes
2 answers
34 views

Log file truncation on AG database

I am POCing AlwaysON DAG for my company, and i have come into a very interesting debacle. Seems like even though primary and replica's and all synced up, the log file on the primary DB does not get ...
user avatar
0 votes
0 answers
575 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 ...
user avatar
  • 133
0 votes
1 answer
67 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 ...
user avatar
4 votes
1 answer
142 views

Distributed AG on SQL Server 2017 Standard Edition?

Can I configure Distributed AG with SQL Server 2017 Standard Edition?
user avatar
0 votes
1 answer
49 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. ...
user avatar
2 votes
0 answers
370 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 ...
user avatar
  • 931
1 vote
1 answer
4k 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 ...
user avatar
2 votes
0 answers
34 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 ...
user avatar
0 votes
1 answer
567 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 ...
user avatar
0 votes
1 answer
553 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....
user avatar
  • 931
3 votes
2 answers
553 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 ...
user avatar
4 votes
1 answer
1k 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 ...
user avatar
  • 43
2 votes
1 answer
130 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 "...
user avatar
1 vote
1 answer
167 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 ...
user avatar
11 votes
2 answers
3k 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 ...
user avatar
  • 931
2 votes
1 answer
1k 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 ...
user avatar
3 votes
2 answers
892 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 ([...
user avatar
  • 175
1 vote
1 answer
263 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 -...
user avatar
  • 151
0 votes
1 answer
213 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 ...
user avatar
  • 2,928
22 votes
3 answers
7k 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 ...
user avatar
  • 9,466
5 votes
2 answers
10k 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 (...
user avatar
  • 53
1 vote
1 answer
601 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 ...
user avatar
  • 21
5 votes
2 answers
3k 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 ...
user avatar
  • 983