MS SQL Database Stuck in 'Restoring'

From Hostek.com Wiki
Revision as of 21:20, 21 April 2013 by Brentb (Talk | contribs) (→‎MS SQL Database Stuck in 'Restoring')

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

MS SQL Database Stuck in 'Restoring'

If you notice in MS SQL Management Studio that a database is stuck in restoring mode, open a new query by clicking on the 'new query' button and enter the following command: 


RESTORE DATABASE [databasenamehere] WITH RECOVERY;

Click on 'Execute'. When you refresh MS SQL Management Studio, the database will be in a normal operational state.

Retrieved from "https://wiki.hostek.com/index.php?title=MS_SQL_Database_Stuck_in_%27Restoring%27&oldid=1297"