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
Archive
Search By Tags
No tags yet.
Follow Us
  • Facebook Basic Square
  • Twitter Basic Square
  • Google+ Basic Square
  • facebook
  • Twitter Round
  • googleplus
  • flickr

© 2014 SATO Database Architects, LLC. SQL Server, SQL Azure are registered trademarks of Microsoft Corporation.