?
Solved

SQL Database Mirroring Between Sites

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

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

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

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
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 extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Suggested Courses

840 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