Post reply

Distributed availability groups failover tips

  • 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

  • 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/

  • 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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply