Solved

SQL active/active db across multiple sites. Possible?

Posted on 2014-09-09
2
104 Views
Last Modified: 2014-09-15
Hi,

First thing, I'm not a SQL expert. I have general knowledge of SQL but it starts to fall away when replication and clustering come into play.

I have a single sql db and associated front-end  application in Site A. I have users connecting from Site B to access the the application/db. I'd prefer to have a copy of the db sitting in Sites B for Site B users, the Site A db for Site A users, all while keeping the copy of the db in Sites A & B  in synch with each other.

What I'd like to know is can I have the db actively being used in both Site A & B with the add/remove/changes being replicated to the alternate site? I'm not after a fail-over scenario where one db is the master and the other the standby db. They both need to be active.

Any suggestions?

Thanks
0
Comment
Question by:AVIVOL
2 Comments
 
LVL 10

Accepted Solution

by:
PadawanDBA earned 500 total points
ID: 40313690
You, sir, sound like you are looking for peer-to-peer replication. http://msdn.microsoft.com/en-us/library/ms151196.aspx.  It's a really complicated little guy due to merge conflicts and conflict resolution.  But that article is a really good jumping in point.  Hope that helps!
0
 

Author Comment

by:AVIVOL
ID: 40324505
Ok. Thanks Padawan.
0

Featured Post

[Webinar] Disaster Recovery and Cloud Management

Learn from Unigma and CloudBerry industry veterans which providers are best for certain use cases and how to lower cloud costs, how to grow your Managed Services practice in IaaS clouds, and how to utilize public cloud for Disaster Recovery

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
A procedure for exporting installed hotfix details of remote computers using powershell
This tutorial will show how to push an installation of Backup Exec to an additional server in both 2012 and 2014 versions of the software. Click on the Backup Exec button in the upper left corner. From here, select Installation and Licensing, then I…
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now