How to recover deleted App Services and database?

Hello @Nuinta ,

Hey Nuinta, sorry to hear about the accidental deletions—let’s tackle App Service and SQL Database recovery separately.

1. Recovering a deleted App Service • Prerequisites – The deleted app must have been in a paid App Service plan (not Free/Shared). – It must have been deleted within the last 30 days. – If it was in an App Service Environment (ASE), the ASE must still exist. • Via the Azure Portal
   1. Go to Azure Portal → App Services.
   2. Click “Manage Deleted Apps” in the top menu.
   3. Select your Subscription and find the deleted app in the drop-down.
   4. Choose an existing target app to overwrite (or create a new blank one first).
   5. Optionally check “Restore App Configuration” if you want settings back.
   6. Click Recover.
   • Via PowerShell
   1. List deletable apps: Get-AzDeletedWebApp -SubscriptionId <your-sub>
   2. Restore: Restore-AzDeletedWebApp -ResourceGroupName <RG> -Name <deletedAppName> -DeletedSiteId <GUID from list> -TargetAppServicePlan <planResourceId>
   3. If you get “Deleted app not found,” verify: – The app wasn’t purged (over 30 days old) – You’re targeting the correct subscription/region – The plan tier supports undelete
   • What doesn’t come back: – Custom domains, TLS bindings and certificates (you’ll need to re-import these).
2. Recovering a deleted Azure SQL Database • If the logical server still exists a) Portal → SQL Server → Deleted databases → select DB → Restore b) PowerShell

    • List deleted backups:  
   
      Get-AzSqlDeletedDatabaseBackup -ResourceGroupName <RG> -ServerName <server>  
   
    • Restore:  
   
      $backup = Get-AzSqlDeletedDatabaseBackup …  
   
      Restore-AzSqlDatabase -FromDeletedDatabaseBackup -DeletionDate $backup.DeletionDate -ResourceGroupName $backup.ResourceGroupName -ServerName $backup.ServerName -TargetDatabaseName <newName> -ResourceId $backup.ResourceID -Edition Standard  
   

   c) Azure CLI

    • List: az sql db list-deleted …  
   
    • Restore: az sql db restore … –deleted-time "<deletion timestamp>"  
   

   • If the server was deleted – You can restore a dropped logical SQL server (preview) only if deleted in last 7 days and the server name hasn’t been re-used. This is best-effort—reach out to Support with:

    • Server name  
   
    • Region  
   
    • Subscription owner approval & business justification  
   

3. Next steps & preventing future mishaps – Put an ARM resource lock on critical resources (CanNotDelete). – Enforce Azure RBAC least-privilege. – Enable long-term backup retention or geo-replication on databases.

Follow-up questions

1. When were the App Services and databases deleted?
2. What App Service plan tiers were in use (Free/Shared vs. Standard/Premium/ASE)?
3. For the databases—were they on Azure SQL Database or Managed Instance? Was long-term retention or geo-replication enabled?
4. Do you still see the logical SQL server in the portal, or was that deleted too?

References

• Restore a deleted web app (portal & PowerShell): https://learn.microsoft.com/azure/app-service/app-service-undelete
• Restore-AzDeletedWebApp: https://docs.microsoft.com/powershell/module/az.websites/restore-azdeletedwebapp
• Recover deleted Azure SQL Database (portal/PS/CLI): https://docs.microsoft.com/azure/azure-sql/database/recovery-using-backups#deleted-database-restore
• Restore a deleted Azure SQL logical server (preview): https://learn.microsoft.com/azure/azure-sql/database/deleted-logical-server-restore?view=azuresql

Note: This content was drafted with the help of an AI system. Please verify the information before relying on it for decision-making.