How do I delete an sql database in Azure?

Question

I have used the following powershell script to delete a database:

Remove-AzureRmSqlDatabase -ServerName $server -ResourceGroupName $rgname -DatabaseName $dbname

(first setting the variables)

and have tried using the Azure Portal

The port indicates a success in deletion, as does the activity logs, however

the resource is not being deleted?

Screenshot of activity log:

The deletes (on a number of occasions after the db comes back) show successful, however there is an audit policy that seems to be doing something. There are no Locks on the resrouce group.

UPDATE:

I have deleted from SSMS, and is not showing there or in the portal anymore.. (will wait to see if it comes back, as it did when deleting via portal and powershell)

UPDATE 2: Database is now back, so this is the database having been deleted 3 ways, portal, powershell and via SSMS.

stackoverflow.com/questions/17085377/cant-delete-azure-database — Sajeetharan
– Sajeetharan, Commented Feb 16, 2020 at 8:39
The Portal indicates a successful delete as does the activity log. and the result of the powershell script is similar to this post: voiceofthedba.com/2017/03/22/… — Mark Redman
– Mark Redman, Commented Feb 16, 2020 at 8:45

Mark Redman · Accepted Answer · 2020-02-17 20:10:01Z

1

It turns out the web application uses EF migrations which is recreating the database.

Note: The bigger issue is that the database is created on a much higher, and much more expensive tier.

answered Feb 17, 2020 at 20:10

Mark Redman

24.6k20 gold badges99 silver badges152 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Peter Kay · Accepted Answer · 2020-02-17 03:00:51Z

0

Do you happen to have a rogue policy somewhere? It seems something is running a Policy Effect: deployIfNotExist on the resource. Without access to your environment, there's not much I could recommend.

Check the documentation here: https://learn.microsoft.com/en-us/azure/governance/policy/concepts/effects#audit

answered Feb 17, 2020 at 3:00

Peter Kay

1,0061 gold badge8 silver badges19 bronze badges

2 Comments

Mark Redman Over a year ago

Thanks, will look into this, I have not specifically created a policy like this but will check.

Mark Redman Over a year ago

The only policy I can see on this is AuditIfNotExists but auditing is not enabled, not sure if this is related?

Collectives™ on Stack Overflow

How do I delete an sql database in Azure?

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related