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(185.6, 74%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERG%3C/text%3E%3C/svg%3E)
I have a 2gb DB that is stuck restoring for over 48 hrs.
It shows as an entry in SSMS but does not show up in the Azure Portal (see image attached)
I cant find any status or logs information in the Azure Portal either...
I have used restore successfully many times clearly something is wrong this time... I have tried use DROP db while connected to the master DB* in SSMS but SSMS says it cant even see the DB.
Any suggestions on what to do?
![](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(297.6, 97%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Hi @Rodney Graham , please let us know if the answer helped.
You can run the following query on the Master database of the Azure SQL Database server to track the progress of a restore.
SELECT major_resource_id, percent_complete
FROM sys.dm_operation_status
WHERE operation LIKE '%DATABASE RESTORE%'
If you don't see any restore then trigger a new one. If you don't see progress on the restore over time, create a support ticket.
Hi guys, thank so much for answering. I tried @Alberto Morillo recommendation but as he mentioned, no restore showed. I planned to then raise a ticket but could not action until the next day... and on returning to it... the restore had completed... 72+ hrs!!!
I have no idea what made it run so long. I have done another one since and it was completed in 10 minutes. Azure Hiccup? Anyhow, if I encounter it again I will be following the above steps...
![](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(204.8, 44%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Hi @Rodney Graham ,
Could you please let me know in which region your server is ? Please let me know in case you still seeing this issue.
Thanks
Saurabh
Hi @Rodney Graham ,
As per internal discussion it looks like an issue with Basic, S0, S1 tiers where restoration service is having some connectivity issues with the SQL instance which products team is currently working on to provide a fix. In the interim if you are using any of these tiers then the best\quickest mitigation is to to restore as an S3 and immediately down-grade it back to the desired target. Hope this helps to resolve your issue.
Also, I suggest you to please open a Support ticket so that products team could dig into any specific issues. In case you have any limitations opening a support please let me know.
Apologies for your inconvenience.
Thanks
Saurabh
![](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(64, 30%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPD%3C/text%3E%3C/svg%3E)
I'm currently having this issue and a Google search brought me here.
The normal restore time for the database in my case is 30mins
However, it's been well over 12hrs and my restore appears to be stuck, I ran the query suggested above, when I ran it against the master database, it shows me that the restore progress is 17%, but it seems to be stuck there.
Also, I can't delete the partly restored database because it's not visible in the Azure Portal, it's visible in SSMS but I can't delete it from there either.
I can't delete the elastic pool that the restored database was meant to be placed.
Does anyone have any idea what I need to do to