What is a retention period of deleted Azure SQL Databases?

Question

I have a question related to Azure SQL Databases.

I know that we can restore databases to any point in time (7 or 35 days) for different tiers in Azure. That is fine.

However, I am wondering how long the deleted Azure SQL databases will be available to restore for.

Does anybody know? Any answer will be appreciated.

Answer 1

Deleted databases can be restored to the point in time of deletion during the retention period of the service tier they were in. (currently that is Basic: 7 days; Standard and Premium: 35 days 7 days).
For more information:
https://learn.microsoft.com/en-us/azure/sql-database/sql-database-business-continuity
https://learn.microsoft.com/en-us/azure/sql-database/sql-database-recovery-using-backups#deleted-database-restore
https://learn.microsoft.com/en-us/azure/sql-database/sql-database-automated-backups

Also, if you delete the SQL server that was hosting the databases, all the backups are GONE instantly.

Backups will be stored till retention period: Microsoft docs quote below(emphasis mine): and this is covered on Overview of business continuity with Azure SQL Database in Perform a point-in-time restore section

You can use the automated backups to recover a copy of your database to a known good point in time, provided that time is within the database retention period.