Difference between revisions of "MS SQL Database Stuck in 'Restoring'"
From Hostek.com Wiki
(Created page with "==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'...") |
(→MS SQL Database Stuck in 'Restoring') |
||
| Line 7: | Line 7: | ||
Click on 'Execute'. When you refresh MS SQL Management Studio, the database will be in a normal operational state. | Click on 'Execute'. When you refresh MS SQL Management Studio, the database will be in a normal operational state. | ||
| + | |||
| + | [[category:Windows-VPS]] | ||
Latest revision as of 21:20, 21 April 2013
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.