Geo-restore in Azure

296 views Asked by At

In the event of a data center outage and I want to restore a SQL database using Azure's geo-restore capabilities, how recent would this backup be?

Some sources explicitly say that it's a daily backup but others indicate that hour differentials and transaction logs are also backed up indicating that you wouldn't lose too much data, definitely not 24 hours worth?

1

There are 1 answers

0
elfisher On BEST ANSWER

According to MSDN, the RPO of Geo-Restore is 24 hours for Pre-V12 servers and 1 hour for V12 servers. If you are using V12 your latest backup would be at most 1 hour old. If you are using Pre-V12 servers your latest backup would be at most 24 hours old.