all groups > sql server replication > november 2003 >
You're in the

sql server replication

group:

merge rep snapshot


merge rep snapshot Leon
11/13/2003 11:24:47 AM
sql server replication:
Hi everyone,
I'm currently running merge replication between two sql2k
(sp3) and win2k(sp4) servers. My question is with the
snapshot. Other than the snapshot agent blocking users
while it bulk-copies the data out, will the merge agent
continue to replicate transcations that come through
during the snapshot process? Thanks.

merge rep snapshot Hilary Cotter
11/14/2003 12:14:26 PM
My understanding is that before the snapshot is done a row
tracking column is added to the table. This row tracking
column will write updates to some metadata tables -
msmerge_contents, etc. Then the snapshot is done or the
tables you are replicating through merge replication, and
the snapshot is also done of the msmerge_contents tables
and other tables. So if a transaction is added to a table
which is being replicated, it is "caught" in the
msmerge_contents table and will be applied if not during
the intial application of the underlying tables, but then
in the application of the msmerge_contents table on the
subscriber.

It does appear that a window does exist where transactions
could be missed, but while trying to repro this I have
been able to do it.

[quoted text, click to view]
merge rep snapshot Leon
11/14/2003 1:53:30 PM
Thanks for the reply. The merge agent seemed to have
caught all of the transactions the last time I ran the
snapshot so I wasn't sure if that was the norm or not.
Thanks again.

[quoted text, click to view]
merge rep snapshot Hilary Cotter
11/15/2003 1:22:55 PM
I'm glad its working. In my post I meant to say, that
although I believe a window might exist when transactions
could be missed, I have been UNable to repro this.
[quoted text, click to view]
merge rep snapshot anitaing
11/21/2003 5:00:06 PM
Just wondered if you had any problems setting up
publications for merge replication. I have s2k sp3a and
w2k. It doesn't work.

Also, the transactions get logged but wait for the
snapshot to finish. You don't lose anything.
[quoted text, click to view]
AddThis Social Bookmark Button