SQL Server Sync Automatically between two sites

Copper Contributor

Hi Team,

We have a Head office and branch, The DB server is located in HO, and from branch they are accessing through SSL VPN. Now there's a power cut-off two hours. So, we are planning to restore the DB. in branch and during the power cut, they can work locally. Another thing the DB in HO needs auto sync to branch. How can I configure for this scenario. Kindly help.

SQL Server 2019 Enterprise.




2 Replies
Help on what exactly/which detail?
Hi Olaf,

We need to sync daily updates from the Head Office to the Branch, we are developing apps, and DB is used for staging.