Guys, I have a rather urgent question.
I setup a design with 2 datacenters where the witness server and the Mirror server are in site B, the principal server in site A. The layer above will be an application server that pushes data from the application server to the database.
Possible issues that he network architecture suggested was:
1) If the network line between the two sites is down ==> Principal disconnected from the witness and mirror. What will happen at that point with the principal as the witness will force the mirror to open and become Active?
=> Will the principal know in this case that the mirror server became the principal and execute a role switch on his own?
2) When the network line between the sites comes back up. Does the principal at that point become the mirror database as the mirror database was previously forced by the witness to become the principal?
The network architecture wants to be sure that both servers are not working as principals when the network line comes back up.
3) If for a weird reason, both the mirror & principal have transactions on each server that haven't been applied to the other side .. Will there be data loss at that point? or what?
Can anyone help?
4 People are following this question.