question

sqlworldwide avatar image
0 Votes"
sqlworldwide asked SadiqhAhmed-MSFT edited

Retention of Geo-backups for dedicated SQL pool

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
image.png (57.7 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @sqlworldwide ,

Welcome to Microsoft Q&A forum and thanks for reaching out.
We are reaching out to internal team to get additional info about this query and will get back to you as soon as we have an update.

Thank you for your patience.

1 Vote 1 ·

1 Answer

KranthiPakala-MSFT avatar image
1 Vote"
KranthiPakala-MSFT answered

Hi @sqlworldwide,

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.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.