Answer / 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.

How you can move data or databases between servers and databases in sql server?

0 Answers  

---

how to write test cases for testing databases,especially for testing and writing test cases for stored procedures.any real time database testers.please answer me.

0 Answers  

---

What is the Main Difference between ACCESS and SQL SERVER?

0 Answers   MindCracker,

---

What is the primary use of the model database?

0 Answers  

---

How to drop an existing stored procedure in ms sql server?

0 Answers  

---

What are the steps to insert a table?

0 Answers  

---

What are the different types of cursor?

0 Answers   HCL,

---

How to display n-1 columns from n number of columns, from a single table in MS SQL server 2005?

2 Answers  

---

What is xml datatype?

0 Answers  

---

If any possiable to use 2 primary key in single table? How many primary key & foreign key used in each table(min & max)?

3 Answers  

---

Can some one please help with a query which will take only max value of a column in a join.

2 Answers  

---

1.what is the purpose of using alias name in sql server? with certain example? 2.what is cursor?will u plz explain me in detail with certain example?

3 Answers  

---