Is there a way to check the progress percent of azure point in time restored databases?
I started a restore of a 750 Gb database, and i do not know whether it has started the restore and the progress percent.
I checked in almost all the system views, but cant find any view that would help me.
Attaching screen shot of how i started the SQL Restore.
At this time, a detailed restore progress is not available on the portal. You can vote for this feature here and it may be considered for future implementation by Azure SQL Database team.
However 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 love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With