Azure sql database geo-restore RTO and RPO

sakuraime 2,316 Reputation points
2021-06-23T03:13:04.543+00:00

Hi RTO is 12 h , and is it base on what size of the database ?
108424-image.png

Azure SQL Database

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anurag Sharma 17,571 Reputation points
    2021-06-23T07:13:27.103+00:00

    Hi @sakuraime , welcome to Microsoft Q&A forum.

    RTO and RPO provided in the table you mentioned is up to those values. As per the article, "If you are using the automated backups with geo-redundant storage (enabled by default), you can recover the database using geo-restore. Recovery usually takes place within 12 hours - with data loss of up to one hour determined by when the last log backup was taken and replicated."

    So recovery could be possible even in less than 12 hours based on different factors like size, regions etc. Same goes with RPO that data loss could be up to 1 hours at max. Same article mentions "the maximum period of recent data updates (time interval) the application can tolerate losing when recovering from an unplanned disruptive event. The potential data loss is known as Recovery point objective (RPO)"

    Please let us know if this helps.

    ----------

    If answer helps, you can mark it as 'Accept Answer'

    1 person found this answer helpful.