Mirroring: Witness and Mirror Fails, how to recover

Last Post 11 May 2012 05:24 AM by NJSQL. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
NJSQL
New Member
New Member

--
10 May 2012 08: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 12: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 05:24 AM
That worked. Thanks
You are not authorized to post a reply.

Acceptable Use Policy