Easy to way to determine Restore and Recovery time.
Simple query to find out SQL Server Database restore time and percentage of completion.
SELECT
percent_complete as percentageComplete
,estimated_completion_time/60000 as timeToComplete
,status
FROM
sys.dm_exec_requests
WHERE
command like '%restore%'
Simple query to find out SQL Server Database recovery time and percentage of completion.
SELECT
percent_complete as percentageComplete
,estimated_completion_time/60000 as timeToComplete
,status
FROM
sys.dm_exec_requests
WHERE
command like '%recovery%'
Source :
Top comments (0)