October 3, 2013 at 3:19 pm
Hi,
I have two databases that I want to make into an AlwaysOn Availability Group. I would like to have synchronous connection between servers with a listener. One of the two databases I would like to have an async connection to a third server be used for reporting purposes.
Is it possible to do this? Not sure if an availability group can be split in that way.
October 4, 2013 at 3:28 am
You can only configure the synch settings for the AG, not per database.
Either synch both databases or create two AG's one having only one secondary and another AG having two secondaries on sychronous and one asynchronous.
[font="Verdana"]Markus Bohse[/font]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy