Groups | Blog | Home
all groups > sql server replication > june 2005 >

sql server replication : Accuracy of replicated data


Leila
6/12/2005 12:00:00 AM
Hi,
I use dial-up connection to replicate data between to servers. Our
replication type is Merge and I'm worried that what happens if the
connection fails when merge agent is working. Will the synchronization be
rolled back or I must necessarily use Transactional replication?
Thanks in advance,
Leila

Leila
6/13/2005 12:00:00 AM
Thanks Christian,
But I'm trying to understand its logic without testing. Because my data are
important and sensitive and I cannot risk for testing!


"Christian Donner" <ChristianDonner@discussions.microsoft.com> wrote in
message news:44A7E2F0-23EC-490E-82CD-820D15257830@microsoft.com...
[quoted text, click to view]

Christian Donner
6/13/2005 3:07:03 AM
"Leila" schrieb:

[quoted text, click to view]

Test it (it should be rolled back - and even if not: the next execution of
the merge agent should synchronize the publisher and subscriber again)!
If you you do not need bidirectional replication it is better to use
transactional replication anyway - it's faster and (unlike the merge
AddThis Social Bookmark Button