loading...

How to find SQL Server database Restore and Recovery time ?

gchandra profile image Ganesh Chandrasekaran ・1 min read

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 :

Discussion

pic
Editor guide