How To Fix A Database Stuck In [Recovery Pending] Status In SQL Server Management Studio



TODO:

SQL Server Management Studio reports a database in "Recovery Pending" status. 

 

SOLUTION:

use master

ALTER DATABASE YourDatabase SET OFFLINE WITH ROLLBACK IMMEDIATE
ALTER DATABASE YourDatabase SET ONLINE WITH ROLLBACK IMMEDIATE


NOTES:

There are no notes on this topic.



Pingbacks and trackbacks (1)+

Add comment

  Country flag

biuquote
  • Comment
  • Preview
Loading