<div>
Are you sure they still aren't mirrored? &nbsp;Isn't the non-primary database in a mirrored configuration always in the restoring state? &nbsp;Maybe they were failed over?
</div>


<div>
Thanks that did it.<br />
<br />
DB's defo no longer mirrored (does not have mirror, synchronised next to it).<br />
<br />
K
</div>


<div>
<div class="content wysiwyg-content">
Hi all, <br />
<br />
I have a SQL 2008 R2 (10.50.1600) server, there are several databases on the default instance that were mirrored but now aren't - they are say in state &quot;restoring&quot;<br />
<br />
I cannot drop them or take them offline in this state, is there a way that I can delete/drop etc. as stopping the SQL server instance is not an option (this is how I would normally tackle this scenario).<br />
<br />
<br />
<br />
Cheers<br />
<br />
K
</div>
</div>


Hi all, 

I have a SQL 2008 R2 (10.50.1600) server, there are several databases on the default instance that were mirrored but now aren't - they are say in state "restoring"

I cannot drop them or take them offline in this state, is there a way that I can delete/drop etc. as stopping the SQL server instance is not an option (this is how I would normally tackle this scenario).



Cheers

K

Are you sure they still aren&#39;t mirrored?  Isn&#39;t the non-primary database in a mirrored configuration always in the restoring state?  Maybe they were failed over?

Thanks that did it.

DB&#39;s defo no longer mirrored (does not have mirror, synchronised next to it).

K

Drop Database In Restore

Hi all, 

I have a SQL 2008 R2 (10.50.1600) server, there are several databases on the default instance that were mirrored but now aren&#39;t - they are say in state &quot;restoring&quot;

I cannot drop them or take them offline in this state, is there a way that I can delete/drop etc. as stopping the SQL server instance is not an option (this is how I would normally tackle this scenario).



Cheers

K

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.