Quick query to return currently restoring databases
- jun127
- Jul 3, 2014
- 1 min read
People need weird thigns for weird reasons. Well, if the thing you need just happens to be:
List of databases that are currently in Restoring... state
We can help. Just run:
SELECT percent_complete , *
FROM sys.dm_exec_requests
WHERE command In ( 'RESTORE DATABASE' )
Commentaires