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

user_6936321 0
Viewed 1160

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.

enter image description here

point-in-time-recovery azure-deployment database-restore azure-sql-database azure
3 Answers

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.

user_69363210

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:

enter image description here

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

enter image description here

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.

enter image description here

user_46523580

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.

user_6405130
Related