January 10, 2009 at 3:47 pm
I am setting up DB Mirroring with protected mode ON in SQL 2K5 but no witness (High Protection mode) , just wanted to check if my mirror is down for one day , will transactions commit on Principle or will just stay as it is with out commit until Mirror is up?
Thanks for your time.
January 10, 2009 at 4:11 pm
From http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx
When a principal database is exposed, it is active with user connections and processing transactions. However, no log records are being sent to the mirror database, and if the principal should fail, the mirror will not have any of the transactions from the principal from the point the principal entered the exposed state. Also, the principal's transaction log cannot be truncated, so the log file will be growing indefinitely.
January 10, 2009 at 4:59 pm
Thanks for reply, just to clarify
it commits the transaction for priciple but keep the T-Log intact and continue to grow since Mirror is not available?
or it does not commit for principle either and T-Log continues to grow?
January 10, 2009 at 5:08 pm
It will commit on the principal, and the transaction log will continue to grow until either the full mirror partnership is back up (so the transactions can be moved over and flushed) or until tell the database to stop mirroring.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply