[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

SQL Database Mirroring Between Sites

Posted on 2013-11-05
5
Medium Priority
?
234 Views
Last Modified: 2013-11-10
We have some EMR software which uses mssql server as the backend and there are issue with speed over a WAN connection. So I have a thought of placing a server at this remote site and doing replication between the two sites. They need to pretty much mirror each other.

Does anyone have some guides on best practices for setting this up?
0
Comment
Question by:lk878787
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 16

Expert Comment

by:DcpKing
ID: 39626306
Are both ends going to be updated at the same time, or is one end going to get the updates and the other only be used for reporting? To start off with I'd delve into the Microsoft docs: one-way transactional replication, where you have amain machine and a secondary that gets the changes but doesn't initiate new stuff itself here, and bi-directional replication, where changes happen at both ends, here.

hth

Mike
0
 

Author Comment

by:lk878787
ID: 39626344
We need them to both be active and keep each other in sync because changes will be made at both.
0
 
LVL 16

Accepted Solution

by:
DcpKing earned 2000 total points
ID: 39627348
So my second reference above applies. Look also at Hilary Cotter's blog post on the subject here (get to see him - he's a great speaker - he was at the Philly SSUG meeting last night!).

hth

Mike
0
 

Author Comment

by:lk878787
ID: 39629100
So with his article, is this the framework of the replication, and can be applied to any kind of database you are using? I already have the emr software setup within this so I'm wondering if I can apply these practices to it.
0
 
LVL 16

Expert Comment

by:DcpKing
ID: 39629234
Normally you would work with the producer of your application software - it would be a large risk to arbitrarily change the database system that your application depends on. It might work, but it might also lead to the software expecting something and not finding it and crashing ...

I don't offhand know what you mean by "EMR", but I would be very loathe to alter the database system any third-party application depends on!

Mike
0

Featured Post

What’s Wrong with Your Cloud Strategy ?

Even as many CIOs are embracing a cloud-first strategy, the reality is that moving to the cloud is a lengthy process and the end-state is likely to be a blend of multiple clouds—public and private. Learn why multicloud solutions matter in this webinar by Nimble Storage.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

656 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