question

ora-6366 avatar image
0 Votes"
ora-6366 asked ·

How to do a clean drop of azure sql databse

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.

azure-ad-connect
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

VaibhavChaudhari avatar image
0 Votes"
VaibhavChaudhari answered ·

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

· 2 ·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks for the detail explanation vaibhav. Is there any way to clean history of Security center,

0 Votes 0 ·

Sorry, not aware of any way to clean history. For my subscription I also can see histoy DBs. Probably try checking below thread and also post a feedback on feedback site

azure-security-center-using-too-much-storage


feedback-azure-security-center


Or maybe post a new question by tagging azure-security-center in it

0 Votes 0 ·