Please I tried to create three database and they are stuck in dropping status, could you help me?

Hello walter, Thanks for posting your query on Microsoft QnA!

Could you please share the latest status of your DBs?

Usually, a database drop operation is quick, but sometimes it can get stuck. This can happen due to a few reasons:

1. The database might have open connections from applications or other services. The drop operation will be blocked until these connections are terminated. You can check for open connections by looking at the active queries in the database or checking the logs of the applications that connect to it.
2. There might be a long-running transaction or another process that is preventing the database from being fully dropped. The service needs to wait for these operations to complete before it can remove the database.
3. In rare cases, there might be a temporary issue with the Azure service itself, preventing the drop operation from completing. In this case, the database should eventually be dropped after the service recovers.

If the status is showing "Deleted" then yes, you will not be charged of the DBs got deleted.

Since you will not be charged while the databases are in the "Dropping" status, the best approach is to wait for the operation to complete on its own.

• Give the system some time to clear the operation. This process might take several hours to complete.
• If you have access to the server, you can check for any active connections or transactions to see if they are blocking the drop.

Open a Support Ticket: If the databases remain in the "Dropping" state for an extended period (more than a few hours), you can open a support ticket with Azure to have them investigate the issue.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Thanks, and Happy to Help!

Pratyush