0

I need advice on setting up synchronization between 2 SQL Server 2016 databases on standalone servers in different sites. What techniques should I best use and how should I go about setting up synchronization?

Currently I have a SQL Server at one site and a second server at a different site.

The requirement is to have database replication from the first site to the second site only.

1
  • Please describe why you need it because there are multiple solution available. There is not enough information to advice you. Feb 24, 2020 at 2:38

2 Answers 2

3

You can go in three ways:

  1. Use replication. This is a large area of ​​database engineering. I recommend you get started with types of replication.

  2. Use log shipping. This is usually used to create an emergency database (hot backup). Pay attention: The secondary server will read-only.

  3. The easiest option. Run backup on the primary server and restore this file on the secondary server. it is a good idea If the restore procedure takes a little time. There are paid cloud services like SqlBak and IBM Cloud Backup that will do it for you.

0

well, in general, without knowing the details of your needs, you can use SQL SERVER log shipping

not the best method in my opinion but it sounds like something that will suit your needs

2
  • 1
    Thanks for your reply. Can i know what are other methods available. My requiremebt is simple , the datsbase in site A should be mirrored to 2nd site B.
    – SHMDBA
    Feb 24, 2020 at 19:07
  • well, when using the log shipping, you are getting a snapshot of the DB, it is more of a constant backed-up DB instead of a replica. when saying Replica, you usually want a replication that is updated in an interval of time, let's say, DB B is 5 minutes late than DB A, and that indeed is a replica. if time is not a factor, log shipping should be fine Feb 24, 2020 at 20:29

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.