Distributed availability groups failover tips

• tony28

  SSCertifiable

  Points: 7114

  More actions

  June 22, 2022 at 6:26 am

  #4053110

  Hello,

  please I have some points for DAG.

  If I will do manual failover, based on documentation  you dont have listener on DAG, so it will be switched from AG1 to AG2 listener.

  But we have problem that application config with listener is not possible easily changed.

  So I have idea create DNS record mapped to Primary AG of DAG for prevent this, and during failover I will also remapped DNS record.

  Or have anybody some another tips how to do in another way?

  I was thinking also about recreate AG listeners, but it will be destroy DAG I guess.

  Thanks

• Michael L John

  One Orange Chip

  Points: 27077

  More actions

  June 22, 2022 at 5:54 pm

  #4053503

  There are a few things when a failover is required.  One, drop and re-create the listener.  Two, modify the connection strings.  Three, modify the DNS records.  Four, use an alias.

  Michael L John
  If you assassinate a DBA, would you pull a trigger?
  To properly post on a forum:
  http://www.sqlservercentral.com/articles/61537/

• tony28

  SSCertifiable

  Points: 7114

  More actions

  June 24, 2022 at 7:14 am

  #4054209

  Hi, thanks for reply.

  I tested recreate listener, but there are problems with cluster permissions, and if you will need to do failover back then can be problems.

  So i will prefer this DNS record I guess.

  Thanks