SQL Tips #41 - Listing the Restore Progress of Databases

Restoring a large database? This query shows the progress percentage of running restore (and other) commands.

The Query

SELECT command, percent_complete, start_time
FROM sys.dm_exec_requests
order by percent_complete desc

Disclaimer

These queries are provided as a guide, and are by no means perfect. I didn't write all of these - many are collated from MSDN documentation and community sources over the years.

Tags