How to do a clean drop of azure sql databse

ora 21 Reputation points
2020-06-05T11:28:56.277+00:00

I am trying to understand the ways to drop and clean azure database completely and to avoid surprise pricing.

I am wondering we can delete it using portal - go database and select and click delete.

if we drop db using SSMS it will not drop the database completely.

Using PowerShell scripts.

Kindly let me know if there are any other ways which can be used for dropping azure database.

I have dropped the database using portal and at security center after dropping using portal , i can still see the dropped db name .Kindly guide how to remove the entry.

security center overview-Data security-Sql -under that i can see still dropped database entry.

when i clicked on the database it is giving message: The resource was not found it may have been deleted .it was launched from a pinned title on the dashboard.

Kindly help where i can remove this entry.

Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
20,543 questions
0 comments No comments
{count} votes

Accepted answer
  1. Vaibhav Chaudhari 38,681 Reputation points
    2020-06-05T13:31:36.93+00:00

    In my opinion, the SQL DB gets deleted completely when you delete it either from Portal or SSMS Drop DB command. I have done that in my personal subscription many times to avoid charges.

    Probably Security center is maintaining the history of SQL DB that you had.


    If the response helped, do "Accept Answer" and upvote it - Vaibhav


0 additional answers

Sort by: Most helpful