Share via

Azure SQL Geo replication Latency

MS Techie 2,751 Reputation points
2021-03-15T13:12:33.523+00:00

I want to replicate data only between few tables from one Azure SQL DB to another Azure SQL DB (PaaS option , not Managed Instance)

i dont want to use Azure Datasync to replicate .

i want to replicate only part of SQL DB using Geo Replication feature.

  1. So what is the Latency of Azure SQL Geo Replication? is it 5 mins or 5 secs or continuous ?
  2. Do i need to create a failover group to achieve this ?

Please help

Azure SQL Database

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Dimitri Furman 161 Reputation points Microsoft Employee
    2021-03-15T22:25:07.55+00:00

    Geo-replication always replicates the entire database. Replication is asynchronous and continuous, with latency below 5 seconds, backed by an SLA. You do not need to create a failover group, though if you do, the database will also be geo-replicated for you. For more information, see https://learn.microsoft.com/en-us/azure/azure-sql/database/active-geo-replication-overview.

    1 person found this answer helpful.
    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.