Unclear RPO and RTO for SQL always on availability group

Assaf L 261 Reputation points
2023-02-27T14:51:43.0633333+00:00

The article about BCDR for SQL Server provides a descriptive information regarding RTO and RPO for using Always On availability group for SQL Server on Azure VM (RTO: The time taken to make the secondary replica as primary, RPO: Because replication to the secondary replica is asynchronous, there's some data loss)

Is there a range of time to provide for these values to consider with expectations we have for our organization?

SQL Server on Azure Virtual Machines
Azure Site Recovery
Azure Site Recovery
An Azure native disaster recovery service. Previously known as Microsoft Azure Hyper-V Recovery Manager.
630 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Carlos Solís Salazar 16,436 Reputation points
    2023-02-28T11:17:18.1066667+00:00

    Thank you for asking this question on the Microsoft Q&A Platform.

    This thread refers to the Overview of business continuity with Azure SQL Database & Azure SQL Managed Instance document
    User's image

    Hope this helps!


    Accept Answer and Upvote, if any of the above helped, this thread can help others in the community looking for remediation for similar issues.