Mirroring: Witness and Mirror Fails, how to recover

Last Post 11 May 2012 06:24 AM by NJSQL. 2 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
NJSQL
New Member
New Member

--
10 May 2012 09:56 AM
If the witness and mirror machines fail, the principle machine's database are put into a (Disconnected / In Recovery ) state.

How do you make these database active and not mirrored?
rm
New Member
New Member

--
10 May 2012 01:17 PM
Break mirroring in ssms or with 'alter database db_name with partner off' on prin***l.
NJSQL
New Member
New Member

--
11 May 2012 06:24 AM
That worked. Thanks


Acceptable Use Policy
---