June 22, 2022 at 6:26 am
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
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
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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy