July 17, 2007 at 1:25 am
Hoping someone can help me with this. I have a SQL 2005 box which was
formerly in a '2005 mirror.' The SQL server containing the
'principal' is now dead (ceased to exist). That is not the problem.
The problem is that I now want to delete the mirror as it is no longer
needed. The status of the mirror is 'Disconnected / In Recovery.'
Problem is that when I try to delete it, I get the message "Database x
is enabled for Database Mirroring, Database Mirroring must be removed
before dropping the database. (Microsoft SQL Server, Error: 3743).
O.K., this is another fine mess you've gotten me into Olly..... Ho do I
delete the 'mirroring relationship' if the server containing the
Principal has 'gone to a better life?' Until I work out how, I will
have to just ignore it and continue to put he server into production.
Not a great option. Thanks in advance.
July 17, 2007 at 1:57 am
You need to change the database state by using
ALTER DATABASE <database_name> SET PARTNER OFF
see also http://technet.microsoft.com/en-us/library/ms189112.aspx
Markus
[font="Verdana"]Markus Bohse[/font]
July 17, 2007 at 2:05 am
Check if this post given below helps you.
http://qa.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=362688
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
July 17, 2007 at 2:46 am
i gone through u all suggestions.still i'm not able to delete or make any actions on mirrored database.
July 17, 2007 at 2:52 am
hi you can remove mirroring as pointed out by earlier persons,now whats the error you are getting......alter database command cud work
[font="Verdana"]- Deepak[/font]
July 17, 2007 at 3:18 am
i'm not able remove mirroring as principal databaase is not showing as principal status.now the status of the database is empty nothing is there.if at all i want configure any database for mirroring it doesnot configuring the mirroring.
July 17, 2007 at 3:42 am
Post the error message that you get when you fire the alter db syntax.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
July 17, 2007 at 4:13 am
July 17, 2007 at 4:49 am
Check if this link help you.
msdn2.microsoft.com/en-us/library/ms180801.aspx
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
January 28, 2009 at 7:31 am
You should restart your endpoint on the MIRROR instance.
alter endpoint [name] state = stopped;
alter endpoint [name] state = started;
You can know your endpoint name with the following query.
select [name] from sys.database_mirroring_endpoints
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply