Sql-server – Sql server database synchronization on 2 different server

sql serversql-data-syncsql-server-2016

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.

Best Answer

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.

Related Question