A developer accidentally executes a DROP TABLE command on a production Azure SQL Database at 2:15 PM.

The database is configured with the default automated backup settings. You need to recover the deleted table with the minimum amount of data loss.

What should you do?

Azure SQL Database provides built-in automated backups, including transaction log backups every 5-10 minutes. This enables Point-in-Time Restore (PITR). To recover from a human error like a dropped table, you use PITR to restore the database to the minute just before the error (2:14 PM). Crucially, Azure SQL PITR always restores to a *new* database on the same server. You would then extract the dropped table from the new database and copy it back to the original.