Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Azure point in time restore - Query for checking progress

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.

enter image description here

like image 541
Raghav Avatar asked Dec 04 '18 12:12

Raghav


1 Answers

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%'
like image 88
Alberto Morillo Avatar answered Sep 24 '22 07:09

Alberto Morillo