Home Forums SQL Server 2016 SQL Server 2016 - Administration sql server cluster and ag node RE: sql server cluster and ag node
Beatrix Kiddo
SSC-Dedicated
Points: 32407
More actions
May 3, 2018 at 7:40 am
#1989077
Yes. Or you can set it so that whenever either A or B is the primary, the other one is read-only, so they can fail over quite happily with minimal intervention from you. You'll need to use a listener to route the connections to the right place.