I dropped an SQL Database on Managed Instance by using SSMS. I dont see the db on Azure but the space was not released. And, I still see the DB on SSMS. How can I complete the drop db ?

Question

I dropped an SQL Database on Managed Instance by using SSMS. I dont see the db on Azure but the space was not released. And, I still see the DB on SSMS. How can I complete the drop db ?

Mehmet Goktas 0

Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator

2023-02-24T18:18:17.2833333+00:00

Hi Mehmet Goktas, thank you for reaching out.

Did you try removing the DB using PowerShell? https://learn.microsoft.com/en-us/powershell/module/az.sql/remove-azsqlinstance?view=azps-9.4.0

Which command did you use?
RahulRandive 10,486 Reputation points Volunteer Moderator

2023-02-25T04:09:42.67+00:00

Hi @Mehmet Goktas

Thanks for asking the question.

This is Rahul who worked today (2/24) on a support case which you raised and resolved your issue 😊

We can close this thread as well.

1 answer

Your answer

Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator

2023-02-24T18:18:17.2833333+00:00

Hi Mehmet Goktas, thank you for reaching out.

Did you try removing the DB using PowerShell? https://learn.microsoft.com/en-us/powershell/module/az.sql/remove-azsqlinstance?view=azps-9.4.0

Which command did you use?
RahulRandive 10,486 Reputation points Volunteer Moderator

2023-02-25T04:09:42.67+00:00

Hi @Mehmet Goktas

Thanks for asking the question.

This is Rahul who worked today (2/24) on a support case which you raised and resolved your issue 😊

We can close this thread as well.

Answer 1

Alberto Morillo 34,671 MVP Volunteer Moderator

The recommended action provided by a Microsoft Employee on StackOverflow is to verify the database is listed if you execute this PowerShell cmdlet and if you see the database listed on the result of the PowerShell cmdlet, then use this other PowerShell cmdlet to remove the database.

If after some hours you still see the database with SSMS or with PowerShell, then please create an Azure support ticket

Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator

2023-02-24T21:03:27.8133333+00:00

Thank you @Alberto Morillo for your answer.

Mehmet Goktas Please try the recommended steps above in reference to the stack overflow that @Alberto Morillo pointed out. If that does not work, then you can create a support ticket so we can further investigate.

Let us know you don't have a support plan.

Regards,

Oury
RahulRandive 10,486 Reputation points Volunteer Moderator

2023-02-25T04:11:11.7066667+00:00

Indeed, a support case was initiated by him, and I proceeded to work on it and successfully resolved the matter.

Share via

I dropped an SQL Database on Managed Instance by using SSMS. I dont see the db on Azure but the space was not released. And, I still see the DB on SSMS. How can I complete the drop db ?

1 answer

Your answer