Retention of Geo-backups for dedicated SQL pool

Taiob Ali 101 Reputation points MVP
2021-05-05T17:16:40.5+00:00

Ref: Geo-backups and disaster recovery

A geo-backup is created once per day to a paired data center. The RPO for a geo-restore is 24 hours. You can restore the geo-backup to a server in any other region where dedicated SQL pool is supported. A geo-backup ensures you can restore data warehouse in case you cannot access the restore points in your primary region.

How many of these backups are retained? I can only see one available backup in the GUI.
94074-image.png

If I run the PowerShell command 'Get-AzSqlDatabaseGeoBackup', I see one entry:
LastAvailableBackupDate : 5/5/2021 4:38:48 AM

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,417 questions
Accepted answer
  1. KranthiPakala-MSFT 46,422 Reputation points Microsoft Employee
    2021-05-06T04:49:02.783+00:00

    Hi @Taiob Ali ,

    I have checked with product team and confirmed that only most recent geo-backup is retained for dedicated SQL pools. No other prior backups are retained.

    Hope this info helps.

    ----------

    Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.

    1 person found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest