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