This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 87%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMJ%3C/text%3E%3C/svg%3E)
I recently created a MSSQL server, which I was trying to move to an elastic pool. In between I initiated the deletion of the database, I received the notification for successful deletion, however, the database is still present. I checked the Activity Logs of the database and it is showing an error, The resource operation completed with terminal provisioning state 'Failed'. , The JSON contains the following message:
The resource operation completed with terminal provisioning state 'Failed'.\",\"details\":[{\"code\":\"InternalServerError\",\"message\":\"An unexpected error occured while processing the request. Tracking ID: '68343e49-e04e-47ff-8d4c-ae34e04e4128
It's been a day now, still unable to delete the database. Can somebody help me with this ? DB Instance is still getting charged. Thanks!
If you have a support plan that permits it, by all means open a support case through the portal. It appears that something has gone wrong on the Microsoft side.
I don't have a support plan, do I need to get one ?, is there any other way to get in touch with Microsoft Support ?
In the portal, click the feedback button in the top list, and you will see this:
Click on the blue i-button, and you will be taken to:
Then you can try Create a support request. Depending on your subscription, you may actually get somewhere, or you may be told that you only have support for billing issues.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 69%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Hi @Mahesh Jaganiya,
Could you please provide an update on your issue, whether your issue has been resolved?
Hi @Mahesh Jaganiya,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution, please do share that same with the community as it can be helpful to others.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 79%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
Try connecting the server using SSMS and execute below T-SQL Command to drop the database and see if it's get deleted.
DROP DATABASE database_name [;]
Thank You!
I get the following response when I try to do that.
The request failed because there is an ongoing 'migration from <Business Critical/General Purpose/Premium/Standard> tier to Hyperscale tier' on server 'SERVER_NAME_REDACTED', database 'DATABASE_NAME_REDACTED'.
It's been migrating for 3 days : |