Home Dashboard Directory Help
Search

Cross Database Transactions-Always on by Aditya Badramraju


Status: 

Active


5
0
Sign in
to vote
Type: Suggestion
ID: 775000
Opened: 12/21/2012 11:04:54 PM
Access Restriction: Public
0
Workaround(s)
view

Description

Recently we are working on a POC to get Always on work and happened to see this article in BOL

http://technet.microsoft.com/en-us/library/ms366279.aspx

This article suggests that there would be logical inconsistency when we are dealing with Synchronous mode too, but will this actually be the case?

Consider for example databases A and B on which the transaction is running and A is in High-safety mode and B is not mirrored. The log of A has to go to Mirrored database then the Primary database commits eventually two phase commit(transaction on B) succeeds but article suggests that log will not be transferred in the first place and results in commit on B which is contradictory. Please help me in understanding Whether the statement suggested in above article is true. If yes how can it be :).

PS :Please let me know if I need to provide more information around this.
Details
Sign in to post a comment.
Sign in to post a workaround.