Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Replication (2005)
 merge replication - a difficult topic
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

United Kingdom
5 Posts

Posted - 08/29/2012 :  10:09:46  Show Profile  Reply with Quote
Hi fellows,
this is a question/topic about merge replication
sql server 2005 sp 2.

I am in the process of reinitialising one of the 700+ subscribers.
more of less in a reinitialisation my process is the following:

Steps for a full reinitialisation:

1) Make sure the machine is connectable

2) Get helpdesk to call the site and get them off the machine until you're done

3) Set cleanedup_unsent_changes to 0 for the site in concord_ods..sysmergesubscriptions

4) Start synchronising, wait until the upload stage is complete.
All of the green tables should have a green tick next to them - if it's a white circle with a tick then it hasn't done

5) Once upload is complete, stop synchronising

6) Generate snapshot for site by starting the snapshot agent
7) Mark for reinitialisation, making sure to take the tick out of the box
8) Start synchronising and wait for finish
9) Make sure that the number of bulk inserts done is much higher than the number of changes

now, on the step 8 I keep having the error below.
can someone please shed some light?
much appreciated.
marcelo miorelli

Error messages:
The merge process was unable to deliver the snapshot to the Subscriber. If using Web synchronization, the merge process may have been unable to create or write to the message file. When troubleshooting, restart the synchronization with verbose history logging and specify an output file to which to write. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201001)
Get help: http://help/MSSQL_REPL-2147201001
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.04 seconds. Powered By: Snitz Forums 2000