Forum Discussion
Solved
60MB Azure SQL database restore taking over 50 minutes?
I kicked off a restore of an Azure SQL Database via the Azure Portal. Its only 60MB in size and is LRS so expected it to be pretty quick. 50+ minutes later it is still "Restoring..." wondered is ...
- In defence of Azure just a bit, the on-prem (private cloud) while more under our control and not shared with thousands of other customers, can have the same issue. Any type of restore would have to take in consideration the weekend full backups.
The solution mentioned above with an Azure VM running SQL is expensive as you said, so your concern would be a good one to raise with your Microsoft account executive and customer success account manager. Both likely would want to know that you provisioned a VM to resolve a concern related to an unmet Azure SQL RTO (Recovery Time Objective) and/or RPO (Recovery Point Objective).
recommend trying again, it should be a quick one.
- thanks. It completed in the end after about 4 hours.
- I had the same issue, small backup/database and took forever. Never figured it out, just went to Azure VM running SQL. Expensive solution. Did you ever get it working quicker?
CJMorganT11020 it seems to be very random. Sometimes it is quick like in a few minutes. Other times it can take a few hours.
I'm starting to think maybe it is stuck in a queue or something.
It is frustrating as we cannot rely on it as now we can't reliably estimate how long a restore takes.
