Distributed Availability Group Failover - SQL Server 2019

Question

Hi All,

Below is our current prod setup. We are planning to failover all AG's to DR site to make as a primary site. After failover we will shutdown primary site (dc1-db1,dc1-db2,dc1-db3 VM's).

Please review below steps and suggest If missed any steps and commands to make DR site as a primary.

setup:
SQL 2019 ent edition
Windows Failover cluster with 6 nodes
Availability mode: synchronous commit

Step 1:

:connect dc2-db1 
ALTER AVAILABILITY GROUP ag1 FAILOVER;
:connect dc2-db2 
ALTER AVAILABILITY GROUP ag2 FAILOVER;
:connect dc2-db3 
ALTER AVAILABILITY GROUP ag3 FAILOVER;

Step 2:
Enable SQL agent jobs on new primary site

Answer 1

Hi @PraveenKumar

For failover of distributed availability groups, you can check this document: https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/configure-distributed-availability-groups?view=sql-server-ver15&preserve-view=true&tabs=automatic#failover.

Hope this can help you.

If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.

Best regards,

Aniya