RTO for cross region restore of sql on VM

Assaf L 281

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?

Assaf L 281 Reputation points

2023-02-27T14:43:56.25+00:00

I was able to find the site recovery service SLA article describing the monthly recovery time objective as lower the 2 hours

Is this the answer?

2 answers

Carlos Solís Salazar 17,971 Reputation points

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

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.
Please sign in to rate this answer.
Assaf L 281 Reputation points

2023-03-02T07:08:59.55+00:00

Hi @Carlos Solis Salazar ,

The details above relate to SQL Database or SQL MI services

I was asking about details for using ASR to recover SQL on VM

Carlos Solís Salazar 17,971 Reputation points

2023-03-02T12:43:12.1233333+00:00

For an ASR environment, I found this:

What is the RTO of a VM failover? Site Recovery has an RTO SLA of two hours. Most of the time, Site Recovery fails over VMs within minutes. To calculate the RTO, review the failover job, which shows the time it took to bring up a VM.

Source:https://learn.microsoft.com/en-us/azure/site-recovery/azure-to-azure-common-questions

Hope this helps!
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
SadiqhAhmed-MSFT 46,041 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
Please sign in to rate this answer.
Assaf L 281 Reputation points

2023-03-02T11:36:46.0466667+00:00

Hi @SadiqhAhmed-MSFT ,

Thanks for the details

I was asking about the RTO value not RPO

Can you share more details on this regard?

SadiqhAhmed-MSFT 46,041 Reputation points Microsoft Employee

2023-03-08T17:04:15.7733333+00:00

Does this answer your question? - https://learn.microsoft.com/en-us/answers/questions/1184701/unclear-rpo-and-rto-for-sql-always-on-availability

Assaf L 281 Reputation points

2023-03-09T15:58:37.0633333+00:00

Hi @SadiqhAhmed-MSFT ,

I'm not sure..

Is cross region restore similar as the always on availability group failover?

SadiqhAhmed-MSFT 46,041 Reputation points Microsoft Employee

2023-03-10T11:11:48.07+00:00

@Assaf L 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

SadiqhAhmed-MSFT 46,041 Reputation points Microsoft Employee

2023-03-16T09:55:22.9833333+00:00

@Assaf L Checking in to see if the above answer helped. If yes, please do "Accept Answer" and Up-Vote it. Let us know if there are still any additional issues we can help with.

Assaf L 281 Reputation points

2023-03-23T12:52:21.26+00:00

Hi @SadiqhAhmed-MSFT ,

There is really no RTO as this is about restoring backup data

ASR and Azure backup services provide RTO for restoring data so I'm not sure I follow here

Nevertheless, from looking at the original article, I could see the CRR is based on ASR inside recovery services vault which has its own RTO, so I assumed this value as answer to my question
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

RTO for cross region restore of sql on VM

2 answers

Your answer