Comments and answers for "Database Mirroring 'split brain' scenario"https://ask.sqlservercentral.com/questions/88956/sql-query.html
The latest comments and answers for the question "Database Mirroring 'split brain' scenario"Comment by pits on pits's answerhttps://ask.sqlservercentral.com/comments/89005/view.html
Thank you Kev,
regarding failover partner,is it placed between Users and Primary/mirror server or The failover partner receives signal of failover from witness server and divert users according to witness server signal? or failover partner work independently and directly with primery/mirror server without any signal from witness server? rgdsFri, 04 May 2012 13:52:57 GMTpitsComment by pitshttps://ask.sqlservercentral.com/comments/89004/view.html
Thank you Kev,
regarding failover partner,is it placed between Users and Primary/mirror server or The failover partner receives signal of failover from witness server and divert users according to witness server signal? or failover partner work independently and directly with primery/mirror server without any signal from witness server?
rgdsFri, 04 May 2012 13:38:47 GMTpitsAnswer by Kev Rileyhttps://ask.sqlservercentral.com/answers/88959/view.html
Your users will be connected to whichever server they are configured to access. If they have (for example) the "Failover Partner =" part in their connection strings, then if they have lost connection to the principal, they will try to connect to the mirror.
It kind of depends on the nature of the loss in connection between the principal, mirror and witness. If the primary is up on Site A, but the link is down between it and the mirror (and witness) on Site B, hence causing the scenario you have described, but the users are also at Site A, then they will still be on the principal.
If the users are at Site C, and there is no break in the link between C->A or C->B, they will probably still be connected to the principal.Thu, 03 May 2012 14:01:01 GMTKev Riley