Solved

SQL active/active db across multiple sites. Possible?

Posted on 2014-09-09
2
103 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

Why do Marketing keep bothering you?

Is your marketing department constantly asking for new email signature updates? Are they requesting a different design for every department? Do they need yet another banner added? Don’t let it get you down! There is an easy way to manage all of these requests...

Join & Write a Comment

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
This tutorial will walk an individual through locating and launching the BEUtility application and how to execute it on the appropriate database. Log onto the server running the Backup Exec database. In a larger environment, this would generally be …
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…

747 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

12 Experts available now in Live!

Get 1:1 Help Now