Two-phased commits are the way to keep multiple servers synchronized.
(Replication also can achieve this)
Two-phased commits are considered to be “Tight Consistency.”
In SQL Server 6.0, We must use the API functions and write some fairly advanced code.
In SQL Server 6.5, The DTC (Distributed Transaction Coordinator) makes the two-phase commit easy to implement.
Asked In: In General |