https://wiki.hostek.com/index.php?action=history&feed=atom&title=MS_SQL_Database_Stuck_in_%27Restoring%27 2026-05-25T07:05:24Z Revision history for this page on the wiki MediaWiki 1.24.2 https://wiki.hostek.com/index.php?title=MS_SQL_Database_Stuck_in_%27Restoring%27&diff=1297&oldid=prev 2013-04-21T21:20:53Z

<p>‎<span dir="auto"><span class="autocomment">MS SQL Database Stuck in &#039;Restoring&#039;</span></span></p> <table class='diff diff-contentalign-left'> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr style='vertical-align: top;'> <td colspan='2' style="background-color: white; color:black; text-align: center;">← Older revision</td> <td colspan='2' style="background-color: white; color:black; text-align: center;">Revision as of 21:20, 21 April 2013</td> </tr><tr><td colspan="2" class="diff-lineno">Line 7:</td> <td colspan="2" class="diff-lineno">Line 7:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>Click on 'Execute'.&#160; When you refresh MS SQL Management Studio, the database will be in a normal operational state.</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>Click on 'Execute'.&#160; When you refresh MS SQL Management Studio, the database will be in a normal operational state.</div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">[[category:Windows-VPS]]</ins></div></td></tr> </table>

Brentb https://wiki.hostek.com/index.php?title=MS_SQL_Database_Stuck_in_%27Restoring%27&diff=1296&oldid=prev 2013-04-21T21:20:37Z

<p>Created page with &quot;==MS SQL Database Stuck in &#039;Restoring&#039;== If you notice in MS SQL Management Studio that a database is stuck in restoring mode, open a new query by clicking on the &#039;new query&#039;...&quot;</p> <p><b>New page</b></p><div>==MS SQL Database Stuck in 'Restoring'==<br /> <br /> 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: <br /> <br /> <br /> &lt;pre&gt;RESTORE DATABASE [databasenamehere] WITH RECOVERY;&lt;/pre&gt;<br /> <br /> Click on 'Execute'. When you refresh MS SQL Management Studio, the database will be in a normal operational state.</div>

Brentb