Restore Progress not available (by SQL Query OR Portal)
We applied the restore of database (deleted database). Restore is in progress but we can-not check the progress of restore.
We use below SQL
SELECT majorresourceid, percentcomplete FROM sys.dmoperation_status WHERE operation LIKE '%DATABASE RESTORE%';
But, precent_completion is showing only 3 values
0- Not started
If we need to check the progress, there is no value to get this info.