asked on SQL 2014 Availability groups and listeners
Hi Experts,
I am using two big SQL servers in one AG.
And I have one Listener for the DBs.
Now I have to copy some more DBs. Is it possible to create another AG with a new listener ?
If yes how many AG are possible and how many Listeners ?
I am using two big SQL servers in one AG.
And I have one Listener for the DBs.
Now I have to copy some more DBs. Is it possible to create another AG with a new listener ?
If yes how many AG are possible and how many Listeners ?
Microsoft SQL ServerWindows Server 2012Microsoft SQL Server 2008
Last Comment
Eprs_Admin
And each AG can have up to 8 database replicas.
ASKER
ok then I try to install a new one.
Thanks a lot.
Thanks a lot.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks a lot.
Mind that you can only have at maximum 2 synchronous replicas and a maximum of 9 replicas (syncs + asyncs).