Is it possible to restore a deleted Sql Server instance in Azure?

Question

I recently deleted a SQL server instance (with 2 sql databases) on my azure portal. I would like to know if there is a way for me to restore the deleted SQL server and the corresponding Sql databases.

I would appreciate any help/direction in this regard.

Thanks

Uma

Answer 1

When you delete SQL Server from portal, you will get a warning : Warning! Deleting xxx is irreversible. So the best solution to this is to open a support ticket.

You could also refer to Can we recover a deleted server for Azure SQL Database? for more information.

Answer 2

Microsoft might be able recover the databases under these conditions:

• Another SQL Server with the same name was NOT created
• Less than 7 days passed since the deletion
• The Region, SQL Server and Resource Group name must be known

You need to log a support ticket. If the server can be recovered, it will be restored. The databases were not restored in my case, but could be recovered using the normal method for recovering a deleted SQL Database within a SQL server.