February 19, 2015 at 1:45 pm
I am new to SQL and trying to figure out if this situation will even work. We would have a master cluster at corporate running 2012 Always on. Each location would have a local server some with SQL Standard 2012 some with SQL Express. The idea is for each remote server to replicate the data back to the master cluster. Would this scenario even work? Please give me your thoughts and feedback.
February 19, 2015 at 1:58 pm
You just mentioned replicate so by setting up replication you can accomplish it.
For Always On to work you must have Enterprise Edition installed in every site.
Here is some reading material on which type of replication to choose:
https://msdn.microsoft.com/en-us/library/bb677158%28v=sql.110%29.aspx
February 19, 2015 at 4:14 pm
So we could setup an Always on Cluster as the Master and than choose a form of replication from the remote sites to the Always on Cluster, and replication would work to the Always on Cluster with say using SQL standard and even SQL Express?
The setup is instead of having a centralized system,it is decentralized and is mandatory for each site to have a server so that the database runs locally and replicates the data back to the main office. My main concern is the replication and corruption of the master database.
February 19, 2015 at 5:18 pm
Please provide more detail about your scenario(s). You haven't given us enough information to help you.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply