How to find SQL Server database Restore and Recovery time ?

#sql #database

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 :