Azure SQL Server DBA

Backup, Restore & Retention

Question

A deleted Azure SQL Database must be recovered from yesterday. Which recovery path fits?

Answer

Use point-in-time restore. Select a time before deletion within short-term retention and restore to a new database; validate data and application configuration before redirecting workloads. This applies to Azure SQL Database.

This is 5 of 19 free samples for Azure SQL Server DBA.

More Azure SQL Server DBA topic samples