April 29, 2013 at 2:55 am
In High safety mode without automatic failover, Principal database waits for the acknowledgement from the mirror database. If changes has been made on the mirror and acknowledgement is sent but it could not reach the principal due to some network/hardware issue , transaction on principal will be rolled back as it could not get acknowledgement . Now what will happen to the data committed on the mirror database ( IN a DR Scenario where no principal is available)
Thanks in advance
Murali
April 29, 2013 at 6:02 am
Mirror will become the Primary.
April 29, 2013 at 6:44 am
Neeraj Dwivedi (4/29/2013)
Mirror will become the Primary.
No, won't be, and transactions will commit without any errors.
Without a witness, you must failover manually and what is worse even in safety FULL without a witness mode you could lost some data if mirror wasn't synchronized.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply