Following scenario : #1 is principal , #2 is mirror . #1 loses network connectivity with everybody (i.e. wire gets cut) I decide to force #2 to be a principal. Now, when network connectivity comes back, do I get 2 principals ? Which one would the .NET applications talk to if #1 is primary and #2 is a partner in connection string ?
You would have one principal after it comes back similar to active /passive mode of clustering. More FAQ'S HERE http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirfaq.mspx regards Sat
