Script to Delete Azure SQL Database if serverName is Null

Question

We have some solutionDB(lets say solution100) that stuck in the creating state so the serverName would be NULL, I have to delete the solutionDB if the ServerName is null.

So first I have to get the list of SQL databases and server names, iterate through the list, and then delete the solutionDB if the serverName is NULL.

Can you please share the code that have tried?

Joseph Idziorek
– Joseph Idziorek

2016-01-27 05:28:30 +00:00
Commented Jan 27, 2016 at 5:28 — Joseph Idziorek
– Joseph Idziorek, Commented Jan 27, 2016 at 5:28

Jack Zeng · Accepted Answer · 2016-01-27 05:35:48Z

3

From what you describe, I guess that you are creating an SQL Database with a new SQL Server. But, the creation is stuck at server level, which means the SQL server has not been created yet. There is no server, so there is no database yet at all. Hence, there is nothing you can delete.

Now, the only thing you need to do is to figure out at what step the creation is stuck.

Here are some hints for you.

Log into the new Portal, click Browse at the left navigation of the page.
Enter Audit Logs to search. And then, click Audit Logs
Click filter, and choose the resource group of your SQL Database to narrow your search.
Now, you will be able to see a column with operation Update SQL database. Click it, and you will be able to see what's wrong with your SQL database creation.

answered Jan 27, 2016 at 5:35

Jack Zeng

2,26714 silver badges23 bronze badges

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

Collectives™ on Stack Overflow

Script to Delete Azure SQL Database if serverName is Null

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related