Quick query to return currently restoring databases

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

#restore #restoredatabase #dmexecrequests

Featured Posts
Recent Posts