Sample Header Ad - 728x90

Query on SQL HA/DR

0 votes
0 answers
55 views
DC1: we have two DB servers (DB1 and DB2) on top of WSFC DC2: 1 DB server (standalone DB machine). I have configured SQL Always-On on DC1 from DB1 to DB2. Now I have to sync/replicate data from DC1-DB1-->DC2-DB3 or DC1-DB2-->DC2-DB3. Please advise how to achive this. Customer is not ready to provide one more DB box on DC2, if i get one more DB machine on DC2, i can use Distributed SQL Always-on for sync from DC1 to DC2 on top of two WSFC's. I am using MS SQL 2017 Ent edition.
Asked by Sridhar G (65 rep)
Feb 6, 2020, 10:39 AM
Last activity: Feb 6, 2020, 03:36 PM