Recover Resource Group and SQL Server and SQL DB within

Helpdesk Milestone 0 Reputation points
2024-04-22T14:16:11.3833333+00:00

I deleted an old Resourge Group with SQL DB within, can i recover within Azure Portal?

We have no Backups.

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,927 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Vinodh247-1375 11,481 Reputation points
    2024-04-22T14:22:39.98+00:00

    Hi Helpdesk Milestone,

    Thanks for reaching out to Microsoft Q&A.

    Unfortunately, once a resource group is deleted, it cannot be directly restored. As a last option you can reach out to support by raising a case and the Azure support team can investigate the situation and attempt to restore the resource group but only on a best-effort basis.

    Please 'Upvote'(Thumbs-up) and 'Accept' as an answer if the reply was helpful. This will benefit other community members who face the same issue.

    0 comments No comments

  2. Abhishek-MSFT 181 Reputation points Microsoft Employee
    2024-04-22T14:23:23+00:00

    Hi,
    Ref : https://learn.microsoft.com/en-us/azure/azure-sql/database/recovery-using-backups?view=azuresql&tabs=azure-portal

    If you delete a server, all of its databases and their PITR backups are also deleted. You can't restore a deleted server, and you can't restore the deleted databases from PITR backups. If you had configured LTR backups for those databases, you can use those backups to restore the databases to a different server.

    You might want to create support request with Azure to see if the Azure SQL Server can be recovered or not. However, deleted resource group itself can not be recovered.

    Suggestion for the future : Implement resource lock to avoide accidental changes to the Azure resources.

    Ref : https://learn.microsoft.com/en-us/azure/azure-resource-manager/management/lock-resources?tabs=json

    0 comments No comments