From reading books online it is clear that there are two types of retention for Azure SQL Database.
- Backups for point-in-time restore
- Backups for long-term retention
When it comes to restore there are multiple options.
- Point-in-time restore
- Deleted database restore
When I think of
Geo-Restore the latest restore point cannot be same as
Point in-time restore as backup has to be copied in a different region/data center.
There is a delay between when a differential backup is taken and when it is geo-replicated to an Azure blob in a different region. This delay can be up to an hour, so, if a disaster occurs, there can be up to one hour data loss.
To find the latest restore point for Geo backup I can use
- How can I find out
LastAvailableBackupDatefor point in-time restore?