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.

 All Forums
 SQL Server 2005 Forums
 Replication (2005)
 REPLICATION

Author  Topic 

thaniparthi.rao
Yak Posting Veteran

96 Posts

Posted - 2008-04-15 : 14:48:23
COULD ANY ONE TELL ME WHETHER TRANSACTIONAL REPLICATION WITH UPDATABLE SUBSCRIBERS IS ONE WAY COMMITMENT OR TWO WAY COMMITMENT AND WHAT IS THE DIFFERENCE BETWEEN THEM

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-04-15 : 22:42:12
One phase commitment, sql will queue transactions if subscriber is not available. In two-phase commitment, transaction can be committed only if both servers are available.
Go to Top of Page
   

- Advertisement -