Share via

Accidentally Deleted Resource Group

DV 0 Reputation points
2025-12-01T13:00:08.1833333+00:00

Hi,

Our company accidentally deleted an old resource group containing an Azure SQL Server and a small database.
The deletion occurred +- 10 days ago on 21 November at 09:11 AM. Is there any way to restore the resource group, or particularly the SQL Server and database? The content is not production-related, however, the database contained an interesting demo dataset.

Any help would be greatly appreciated.

Thanks in advance,

Kind regards,

Azure SQL Database

Answer recommended by moderator

TP 156.7K Reputation points Volunteer Moderator
2025-12-01T14:35:38.8366667+00:00

Hi,

To restore your Azure SQL Server you would need to create a Technical support request in the Azure portal and then a backend engineer will restore it. To create a Technical support request in the portal you need at least Standard level support. After your request is resolved you can downgrade.

You may use below link to upgrade to Standard if necessary:

https://portal.azure.com/#view/Microsoft_Azure_Support/HelpAndSupportBlade/~/supportPlans

When creating the request, select Severity A (<1 hour response) since it has already been 10 days. I'm unsure the maximum number of days before they can no longer restore it for you which is why I suggest treating it as higher priority.

Create an Azure support request

https://learn.microsoft.com/en-us/azure/azure-portal/supportability/how-to-create-azure-support-request

NOTE: Creating support request can be confusing. If you feel you are stuck in an endless loop add a comment below and I can give more detailed instructions.

Please click Accept Answer and upvote if the above was helpful.

Thanks.

-TP

Was this answer helpful?

1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Manoj Kumar Boyini 15,225 Reputation points Microsoft External Staff Moderator
    2025-12-01T14:39:35+00:00

    Hi DV,

    Thank you for reaching out to Microsoft QA. Please share the requested details in the Private Messages section at your convenience.
    it looks like you're in a tough spot after accidentally deleting your resource group that contained an Azure SQL Server and a database. Unfortunately, once a resource group is deleted in Azure, there's no supported way to recover it, and that includes the SQL Server and its associated databases.

    Here’s a breakdown of the situation based on the information provided:

    1.Deletion is Irreversible: When the resource group was deleted, all related resources, including the Azure SQL Server and databases, were also deleted permanently. The Azure SQL databases cannot be recovered once the server is gone and unfortunately, any backups that might have existed were also deleted.

    2.Long-Term Retention (LTR) Backups: If you had LTR backups enabled for your database, you might be able to restore it to a new server. If you haven’t checked yet, you can use the following command to see if any LTR backups are available:

    az sql db ltr-backup list --location <your_location> --subscription <your_subscription_id>

    If LTR backups exist, you can restore the database from one of those backups to a new SQL Server.

    3.No Server Recovery Options: There’s currently no official way to restore a deleted server, and even if a new server with the same name is created, the recovery won't work. The only reliable method remains via LTR backups, if they were configured before the deletion.

    4.Future Prevention: To prevent this from happening again, consider enabling Resource Locks on important resource groups and databases. This can help guard against accidental deletion in the future.

    Here are some links to relevant documentation for your reference:

    1.Recover dropped SQL Servers and databases following resource group deletion

    2.Long-term backup retention (LTR)

    3.Prevent and recover from accidental deletions

    Please let us know if you have any questions and concerns.

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.