When using multiple basic AGs is it recommended to use 1 listener or mirroring endpoint?
0
votes
1
answer
152
views
I want to setup HA DR for a single instance SQL server by adding a new instance on another machine and configuring multiple basic AGs (**with manual failover mode**).
I want all client apps to be able to use the same connection string to reach the server. For this do I use the listener (create a listener for only 1 AG, and use this in all connection string) or do I use the database mirroring endpoint?
Asked by variable
(3590 rep)
Sep 27, 2023, 06:15 AM
Last activity: Sep 27, 2023, 07:21 AM
Last activity: Sep 27, 2023, 07:21 AM