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
- Geo-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 Get-AzureRmSqlDatabaseGeoBackup
command.
Question:
- How can I find out
LastAvailableBackupDate
for point in-time restore?