|
Home > Archive > MS SQL Server > October 2006 > DROP a Mirrored DB
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
DROP a Mirrored DB
|
|
| shaun.steckley@gmail.com 2006-10-24, 6:37 pm |
| I setup Database Mirroring for the first time on SQL 2005 SP1 and am at
a point where I want to delete the mirrored test database. However,
when I try to drop the DB on the mirrored server I receive an error.
It won't let me delete the DB since it is in "In Recovery" mode. What
do I have to do to DROP this database? The copy on the primary server
is already removed?
---
Msg 3743, Level 16, State 1, Line 1
Database Mirror_Test is enabled for Database Mirroring, Database
Mirroring must be removed before dropping the database.
---
| |
| shaun.steckley@gmail.com 2006-10-24, 6:37 pm |
| Found out how.
ALTER DATABASE Mirror_Test SET PARTNER OFF
shaun.steckley@gmail.com wrote:
> I setup Database Mirroring for the first time on SQL 2005 SP1 and am at
> a point where I want to delete the mirrored test database. However,
> when I try to drop the DB on the mirrored server I receive an error.
> It won't let me delete the DB since it is in "In Recovery" mode. What
> do I have to do to DROP this database? The copy on the primary server
> is already removed?
>
> ---
>
> Msg 3743, Level 16, State 1, Line 1
> Database Mirror_Test is enabled for Database Mirroring, Database
> Mirroring must be removed before dropping the database.
>
> ---
| |
| John Bell 2006-10-24, 6:37 pm |
| Hi Shaun
Check out http://msdn2.microsoft.com/en-us/library/ms180801.aspx for
instructions or look in Books Online.
John
"shaun.steckley@gmail.com" wrote:
> I setup Database Mirroring for the first time on SQL 2005 SP1 and am at
> a point where I want to delete the mirrored test database. However,
> when I try to drop the DB on the mirrored server I receive an error.
> It won't let me delete the DB since it is in "In Recovery" mode. What
> do I have to do to DROP this database? The copy on the primary server
> is already removed?
>
> ---
>
> Msg 3743, Level 16, State 1, Line 1
> Database Mirror_Test is enabled for Database Mirroring, Database
> Mirroring must be removed before dropping the database.
>
> ---
>
>
|
|
|
|
|