What is Two-Phase Commit ?

 Posted by Pandians on 7/23/2009 | Category: Sql Server Interview questions | Views: 3811

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 | Alert Moderator 

Comments or Responses

Login to post response