DEV Community

Ganesh Chandrasekaran
Ganesh Chandrasekaran

Posted on

2 1

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)

Billboard image

The Next Generation Developer Platform

Coherence is the first Platform-as-a-Service you can control. Unlike "black-box" platforms that are opinionated about the infra you can deploy, Coherence is powered by CNC, the open-source IaC framework, which offers limitless customization.

Learn more