Solved

SQL Database Mirroring Between Sites

Posted on 2013-11-05
5
219 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 500 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

696 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