?
Solved

SQL Database Mirroring Between Sites

Posted on 2013-11-05
5
Medium Priority
?
229 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

Portable, direct connect server access

The ATEN CV211 connects a laptop directly to any server allowing you instant access to perform data maintenance and local operations, for quick troubleshooting, updating, service and repair.

Question has a verified solution.

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

Resolve DNS query failed errors for Exchange
An article on effective troubleshooting
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Suggested Courses

764 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