Solved

SQL Database Mirroring Between Sites

Posted on 2013-11-05
5
210 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
  • 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Issue: One Windows 2008 R2 64bit server on the network unable to connect to a buffalo Device (Linkstation) with firmware version 1.56. There are a total of four servers on the network this being one of them. Troubleshooting Steps: Connect via h…
Know what services you can and cannot, should and should not combine on your server.
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.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

895 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

16 Experts available now in Live!

Get 1:1 Help Now