Okay honestly I have done this once. I have deleted Azure SQL Databases and then try and find the quickest way to recover. The Azure portal is actually pretty good when it comes to deleting resources, for example it will usually ask you to re-type the name of the resource to confirm deletion, so you can tell what a bad mistake I made.

Let’s look at how to delete a database then recover it. Simply navigate to the “logical” SQL Server and find the delete option within the portal.

Here is the warning I mentioned earlier on.

I type the name to confirm and then whoops, I realise the mistake.

So what does one do? Navigate to the main left menu bar within the SQL Server and under settings look for “Deleted Databases”.

Here you will be presented with the deletion times for the various databases. Select the one of interest (in our case CommDB). Note the restore point time.

Click OK and you will have the deleted database back.  Hopefully this post will help you out one day! Do not forget to the alter the name of the database to the original name.