Azure Sql DB Restore not showing up in Azure portal but stuck restoring in SSMS

Question

I have had an Azure SQL DB point in time restore running for two days. I want to cancel it as I think there is an issue. I can see the DB restoring in SSMS but can't find the deployment in my Azure Portal. Does anyone know how to cancel it? I have tried using Azure CLI but I can't see the resource.

Answer 1

It's called Azure Hiccups, it happened to me yesterday on Switzerland West region between 10:20 and 10:40.

I re-run it and everything was fixed.

If I check the Activity Log I can see the error:

But if I browse in the Service Health it says everything was good:

What to do in case of Azure Hiccups:

1. FIX: Re-run the task, hopefully it will fix the issue, like when you hit an old TV with your fist.
2. PREVENT: You can try to create an Activity Log alert but once again it will be based on Service Health (which says that everything is good) and not on the actual Activity Log. So you will probably miss issues like this and will discover the problem 24h later.
3. POST-MORTEM: You can take a screenshot of the failed task/service in the Activity Log, show it to Microsoft and ask for a refund if possible. For the future you can check the current status of Azure in the official Status page and subscribe to the RSS feed. You can browse the Azure Status History. But as I said none of the last two reports the Azure Hiccups so the screenshot of the Activity Log is still the only proof that a tree yesterday has fallen in the forest.

As Microsoft SLA says that the High availability for Azure SQL Database and SQL Managed Instance is 99.99% of the year you can start collecting those screenshot and open tickets with their support.

Answer 2

After dropping the Database this morning, the operation status of which was unsuccessful. The Restore has finally been canceled 8 hrs after attempting to drop the database.

Answer 3

Found a solution, just create a new database of the same name. And the restoring one will be replaced with the one created, then you can delete it.