Forum Discussion

ShabinSGS's avatar
ShabinSGS
Copper Contributor
Nov 02, 2023

SQL Server Sync Automatically between two sites

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.

 

Thanks,

Shabin

2 Replies

Sort By
    • ShabinSGS's avatar
      ShabinSGS
      Copper Contributor
      Nov 03, 2023
      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.

      Thanks.

Resources