September 11, 2020 at 8:03 am
Hi
Can anybody tell me, when setting up Basic Availability Groups in a 2 node cluster, do you require a separate listener for each DB you create into a new B.A.G ? (or could the app just connect via cluster ip?)
Thanks
September 11, 2020 at 9:49 am
Create your availability group, configure the listener, add databases. Add as many databases as you need
Application connects using listener name, think of that as your new server name. Connection string will need a database name as well
September 11, 2020 at 11:10 am
Create your availability group, configure the listener, add databases. Add as many databases as you need
Application connects using listener name, think of that as your new server name. Connection string will need a database name as well
Sorry but I think this is incorrect? The OP referred to a Basic Availability Group which can only have one database in each availability group.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply