April 26, 2010 at 3:37 am
In high protection mode all transactions must be committed on the mirror before being committed on the principal. what happens if the mirror goes offline for whatever reason? Will this bring the principal server to a halt?
April 26, 2010 at 3:37 pm
depends how much space you have for your transaction log.
Principal will continue to function but log will not be able to be backed up. so would eventually run out of space. How long that takes depends on how busy your system is and how much space available.
High performance mode the transactions still have to be passed to the mirror so this is just the same in this regard
---------------------------------------------------------------------
April 27, 2010 at 3:40 pm
Most likely the two servers will become unsynchronized for the duration of the outage, and sync up when they can talk again. The bigger concern would be that the principal also loses connectivity to the witness - at that point the principal has to make an assumption that a failover has occurred, and therefore will stop accepting connections. Microsoft recommend removing the witness if the mirror will be down for any significant length of time to avoid this scenario.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply