azureazure-sql-databasedatabase-restoreazure-deploymentpoint-in-time-recovery

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


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


Solution

  • 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