Azure SQL Database
An Azure relational database service.
5,771 questions
Azure SQL Database Reappears After Deletion
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(304, 35%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETT%3C/text%3E%3C/svg%3E)
Thanasis Tsolos
0
Reputation points
While trying to delete an SQL database in my Azure subscription, I noticed that after deleting it twice, the database reappears after some time. Additionally, I was charged about 100 euros after the first deletion. What could be causing this, and how can the database be permanently removed?
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 46%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
NIKHILA NETHIKUNTA 3,265 Reputation points Microsoft Vendor2024-11-11T05:29:30.8566667+00:00 @Thanasis Tsolos
Thank you for the question and for using Microsoft Q&A platform.It seems like you are experiencing an issue with deleting your SQL database in Azure.
- Based on the information you provided; it is possible that the database has been configured with soft delete enabled. Soft delete is a feature that allows you to recover deleted resources within a certain retention period. To permanently delete a resource with soft-delete enabled, you need to disable the soft-delete feature for that resource. You can do this by using the Azure portal, Azure PowerShell, or Azure CLI.
https://learn.microsoft.com/en-us/azure/backup/backup-azure-security-feature-cloud?tabs=azure-portal#enable-and-disable-soft-delete - Check Automated Backups: Azure SQL Database automatically creates backups that can be used to restore a deleted database. Ensure that there are no automated processes or policies in place that might be restoring the database.
https://learn.microsoft.com/en-us/azure/azure-sql/database/recovery-using-backups?view=azuresql&tabs=azure-portal - Verify if there are any resource locks applied to the database or its resource group. Resource locks can prevent accidental deletions but might also interfere with intentional deletions. Ensure that there are no resource locks on the database or its resource group.
https://techcommunity.microsoft.com/blog/azuredbsupport/protecting-deletions-of-azure-sql-resources/368903
Once the above steps are completed, delete the database again.
Hope this helps. Please let us know if you have any further questions. - Based on the information you provided; it is possible that the database has been configured with soft delete enabled. Soft delete is a feature that allows you to recover deleted resources within a certain retention period. To permanently delete a resource with soft-delete enabled, you need to disable the soft-delete feature for that resource. You can do this by using the Azure portal, Azure PowerShell, or Azure CLI.
-
NIKHILA NETHIKUNTA 3,265 Reputation points Microsoft Vendor
2024-11-12T18:38:37.6566667+00:00 @Thanasis Tsolos
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Sign in to comment
Sign in to answer