This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](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(83.2, 25%, 18%)' 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)
Hi, I am using a SQL database in Azure SQL Server. Recently, my database keeps being deleted without me noticing. When I figured it out, the database has been deleted. Luckily, I can restore it from Azure. But it keeps happening. So can anyone tell me what is going on?
Fyi, I only have one database in the SQL Server.
Thank you very much!
![](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(220.8, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Hi Nguyễn Trần Phong •,
We haven't heard back from you. In case you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.
Thanks
To investigate what is happening, you should use your Azure Activity Logs and look for the delete records.
I would also advise that you leverage Resource Locks on the SQL Database resource to prevent it from being deleted.
Hey, thank you for answering my question. I have looked at the activity log of the delete action but I barely found something that can help me figure out what's going on. Because no one of my team did this and I am thinking of any auto-trigger on Azure 🥲
Also I configured the Resource Lock as well.
Hi Nguyễn Trần Phong •,
Welcome to Microsoft Q&A forum.
We are sorry about the inconvenience you are facing.
As I understand, your Azure SQL database is getting deleted.
The problem looks strange as mentioned that in activity log also there is no trace.
You could try to review if there is any Azure Policy which might be responsible for such operation.
Also, check if you could find the missing Database in Azure CLI if not via Portal.
If these options do not help, I would recommend you to raise support case for deeper investigation of the issue.
If you face any issue or need assistance do let us know.
Thank you.