RTO for cross region restore of sql on VM

Assaf L 261 Reputation points
2023-02-27T13:14:20.6+00:00

Based on this article there is an RPO definition for using cross region restore for a sql database on VM

I couldn't find what is the RTO for this type of ability?

Is it documented somewhere?

SQL Server on Azure Virtual Machines
Azure Backup
Azure Backup
An Azure backup service that provides built-in management at scale.
1,134 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Carlos Solís Salazar 16,696 Reputation points MVP
    2023-02-27T21:31:42.5833333+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.

  2. SadiqhAhmed-MSFT 38,551 Reputation points Microsoft Employee
    2023-03-02T07:41:45.1733333+00:00

    @Assaf L The Recovery Point Objective (RPO) for the backup data to be available in the secondary region is 12 hours. When you turn on Cross Region Restore (CRR), the RPO for the secondary region is 12 hours + log frequency duration (that can be set to a minimum of 15 minutes). You can find more information about Cross Region Restore in the article "Restore SQL Server databases on an Azure VM"

    Update:

    Is cross region restore similar as the always on availability group failover?Cross region restore is just for backups.

    So essentially now there is a guaranteed 24hr RPO to have the data in the other region. At that point the customer can restore the data whenever needed.

    There is really no RTO as this is about restoring backup data, not doing a failover.

    SQL AG is a DR solution. It keeps multiple copies of the same data available on different SQL servers in case one goes down. If that is what you are needing, then you want to look at ASR and for it the RPO and RTO can be modified to fit as per your requirement. (adjusting recovery point increments etc).

    Common questions about Azure VM disaster recovery with Azure Site Recovery - Azure Site Recovery | Microsoft Learn

    Hope this helps! Please reply if you have more questions.

    If the response helped, do "Accept Answer" and up-vote it