Question : So I was creating a distributed availability group and noticed I wanted to change the name of the […]
Tag: distributed-availability-groups
Single node availability group – is it possible?
Question : Is it possible to have an availability group with just one node in it? The reason I ask […]
Cannot remove Database from Distributed AlwaysOn Group on Secondary Windows Cluster
Question : We have Distributed AG across two windows clusters. Clus01 – Has an AG set up with no DB […]
Remove database from Distributed Availability Group replica AG ONLY!
Question : all! I have an existing always on availability group on-prem and last week created a second one in […]
Distributed Availability Group Failover Issue
Question : I have created Distributed Availability group set up as below: In Data center A, created 2 node AG1 […]
Error in AG Dashboard when looking at a Distributed AG
Question : I have a Distributed AG, but whenever I go to look at the AG Dashboard it says “An […]
Can Availability Group be configured in a below structure?
Question : I have Production and DR clusters as depicted on a picture below. My question is whether there is […]
SQL Server Distributed Availability Group databases not syncing after a Global Primary Replica Failover
Question : SQL Server Distributed Availability Group Environment AG1 => Node1 (AG1-Global Primary) and Node2 (AG1 – Secondary Replica) AG2 […]
Get DAG members
Question : 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 […]
Upgrade with DistributedAG vs adding a node with SQL Server 2019
Question : We would like to migrate from SQL Server 2016 to SQL Server 2019. The databases are part of […]
- 1
- 2