Sample Header Ad - 728x90

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