Unable to delete Cloud SQL instance

[bearabuddyrichi]

Hi, I'd really appreciate some help in deleting the Cloud SQL instance. It is picking up cost even after the instance has been stopped. Also it has crossed the billing threshold and is expected to go way beyond the allowed limit. This was created as a test an automation however it has been not used at all. I have read documentation which says I could edit it and delete it however although being the Cloud Admin Im unable to edit or delete the instance.  Help please!!

[jitu028]

Hi @bearabuddyrichi 

What error are you getting when deleting the instance? 

Check if delete protection is enabled on the instance.

Click on overview tab of the instance, and check the configuration to ensure "Instance deletion protection is disabled"

If it's enabled you can't delete the instance.

[bearabuddyrichi]

Hi @jitu028 ,

Thanks for  your response. Yes, it says delete protection is enabled and it asks me to go to edit and remove the delete protection. But all these options are greyed out. There is no error jus that its all greyed out and unclickable. 

[jitu028 · Accepted solution]

Hi @bearabuddyrichi 

You need to start the instance first so you can edit the configuration to disable deletion protection.
this should let you delete the instance.

[bearabuddyrichi]

Hey @jitu028 ,

I feel like a .... Thank you for pointing that out. 

[jitu028]

Happy that it fixed the issue.