[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

SQL active/active db across multiple sites. Possible?

Posted on 2014-09-09
2
Medium Priority
?
115 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 1500 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

Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

Question has a verified solution.

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

Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
After seeing many questions for JRNL_WRAP_ERROR for replication failure, I thought it would be useful to write this article.
This tutorial will walk an individual through the steps necessary to configure their installation of BackupExec 2012 to use network shared disk space. Verify that the path to the shared storage is valid and that data can be written to that location:…
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…

591 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