Accidentally deleted all resources in a resource group (including sql servers)

Question

Accidentally deleted all resources in a resource group (including sql servers)

Jonathan Chase 21

I ran an ARM template with deploymentMode complete on the wrong resource group. I am in the process of manually recreating deleted resources but I wanted to know if there are any disaster recovery options for this scenario. It does involve lost sql servers and a large amount of lost data.

SwathiDhanwada-MSFT 18,991 Reputation points Moderator

2023-04-26T06:59:59.8366667+00:00

@Jonathan Chase Did you get chance to look into my previous comment? Kindly revert if you have further questions.
SwathiDhanwada-MSFT 18,991 Reputation points Moderator

2023-05-02T05:18:40.3866667+00:00

@Jonathan Chase Hope the information provided is useful. Let me know if you have further questions.

Accepted answer

0 additional answers

Your answer

SwathiDhanwada-MSFT 18,991 Reputation points Moderator

2023-04-26T06:59:59.8366667+00:00

@Jonathan Chase Did you get chance to look into my previous comment? Kindly revert if you have further questions.
SwathiDhanwada-MSFT 18,991 Reputation points Moderator

2023-05-02T05:18:40.3866667+00:00

@Jonathan Chase Hope the information provided is useful. Let me know if you have further questions.

Answer 1

SwathiDhanwada-MSFT 18,991 Moderator

@Jonathan Chase Welcome to Microsoft Q & A Community Forum. To redeploy the last successful deployment, add the -RollbackToLastDeployment parameter as a flag.

New-AzResourceGroupDeployment -Name ExampleDeployment02 `
  -ResourceGroupName $resourceGroupName `
  -TemplateFile c:\MyTemplates\azuredeploy.json `
  -RollbackToLastDeployment

To redeploy a specific deployment, use the -RollBackDeploymentName parameter and provide the name of the deployment. The specified deployment must have succeeded.

New-AzResourceGroupDeployment -Name ExampleDeployment02 `
  -ResourceGroupName $resourceGroupName `
  -TemplateFile c:\MyTemplates\azuredeploy.json `
  -RollBackDeploymentName ExampleDeployment01

If you have backups of your SQL servers, you can restore them to recover your data. You can use Azure Backup or other backup solutions to create and manage backups of your SQL servers. If you are unable to recover your resources using the above methods, you can contact Azure Support for assistance. They may be able to help you recover your resources or provide guidance on next steps. References : https://learn.microsoft.com/en-us/azure/azure-resource-manager/templates/rollback-on-error

Jonathan Chase 21 Reputation points

2023-05-02T06:31:55.36+00:00

Very helpful thank you. Is there any way to deny all ARM templates being used in Azure Devops from being able to delete resources?
SwathiDhanwada-MSFT 18,991 Reputation points Moderator

2023-05-02T07:36:56.32+00:00

@Jonathan Chase You can use lock feature which prevents either deletions or modifications. As an administrator, you can lock an Azure subscription, resource group, or resource to protect them from accidental user deletions and modifications. The lock overrides any user permissions. It denies deletion of resources from any of the tools (Azure CLI, Azure PowerShell etc), unless the lock is removed.

From more information, refer this document.

Share via

Accidentally deleted all resources in a resource group (including sql servers)

0 additional answers

Your answer