Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ranvir_2k
Posting Yak Master
180 Posts |
 Posted - 2009-10-08 : 15:20:49
|
| I understand in high safety mode a transaction will only commit on the principle once it has committed on the mirror.What would happen in the following situation, if it is even possible:The transaction is committed on the mirror but the transaction fails to commit on the principal. |
|
|
ranvir_2k
Posting Yak Master
180 Posts |
Posted - 2009-10-09 : 06:18:49
|
| Any replies? Is this situation possible? Can a transaction be comitted on the mirror and then fail to be committed on the principal? |
 |
|
|
support.sql
Starting Member
15 Posts |
Posted - 2009-11-29 : 11:31:58
|
| Here is the process done by Mirroring Technology 1. Apply the change to the principal, but do not yet commit the transaction.2. Apply the change to the mirror. Roll back if there's an error, otherwise commit.3. If the mirror rolled back the transaction, then roll back the principal. Otherwise commit the principal.4. Return the success or failure of the transaction to the client.SNMTry Free Microsoft SQL Server Data Collector & Performance Monitor.http://www.analyticsperformance.com@nalyticsperformance - Microsoft SQL Server & Windows Server Free Data Collector |
|
|
|
|
|
|
Mirroring two phase commit