February 10, 2014 at 8:05 am
I am working on a proof of concept using Always On. What I am trying to do is create single secondary replica to be used by two or more Primaries. For example, database One and Two on Server A will send data to a secondary replica on Server C. And database Three on Server B will send data to a secondary replica also on Server C. We are looking to use Server C for reporting only and move the I\O off the primary. Is this even possible? We are not looking to do this for high availability, but to use Server C as a real time reporting server. Yes, would could use Transactional Replication, and that is still an option, however we want to know if Always On is also an option.
February 10, 2014 at 9:16 am
This should be possible and is easy enough to test out once you have the 3 serves in a Windows Server Failover Cluster, which is a required starting point anyway. As long as they are different databases and different AGs you should be good.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply