DEV Community 👩‍💻👨‍💻

Ganesh Chandrasekaran
Ganesh Chandrasekaran

Posted on

How to find SQL Server database Restore and Recovery time ?

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%'

Enter fullscreen mode Exit fullscreen mode

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%'

Enter fullscreen mode Exit fullscreen mode

Source :

Top comments (0)

We want your help! Become a Tag Moderator.
Fill out this survey and help us moderate our community by becoming a tag moderator here at DEV.