Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / k v n subba reddy
In high availablity mirroring if the connection between
witness server and primary server is break off but if
primary server is still up. The witness server will up
mirror server. In this scenario both primary server and
mirror server is up and this scenario is called as SPLITBRAIN.
Question1 : In this case the users are connected to primary?
or mirror server?
Question2 : Once the connection between witness server and
primary server break even primary server is up , are users
connected to primery server or secondary server?
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.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration
How check triggers in sql server?
Determine when to use stored procedure to complete sql server tasks?
What are the types of stored procedures in an sql server?
Explain trigger and its types?
What are the two modes of authentication in sql server?
What is 2nf normalization form?
What is BCNF? How is it better than 2NF & 3NF?
How to start and end transact-sql statements?
How to enter date and time literals in ms sql server?
How to throw custom exception in Stored Procedure?
Tell me when is the update_statistics command used?
how to invoke a trigger on demand? : Sql server database administration
How you can get the list of largest tables in a database?
What is an etl file?
