I have a SQL VM on Azure. I need to replicate a database from this virtual machine to another SQL virtual machine to another cloud network (transactional replication).
If I configure the distributor for a separate SQL virtual machine, I still have a chance that this computer will fail by skipping some transactions. I read that the distributor database cannot be mirrored or used as part of an availability group , and Azure SQL virtual machines d o do not support AlwaysOn failover cluster instances.
How can I guarantee that my distributor’s database will not go down and that my replication will always work?
source
share