Sql server database synchronization on 2 different server 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.
You can go in three ways:


Use replication. This is a large area of ​​database engineering. I recommend you get started with types of replication.
Use log shipping. This is usually used to create an emergency database (hot backup). Pay attention: The secondary server will read-only.
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.