I have created a Merge replication between 2 SQL 2000 servers. The one
server is configured to do a Pull (non anonymous) and the snapshot is being
downloaded over ftp.
If I add a table to the replication, I get a message indicating that I must
generate a new snapshot before changes from any subscriber can be merged.
It also indicated that only the snapshot of the new article will be used to
sync existing subscriptions.
I create the new snapshot, but when the server synchronized, I get an error
The schema script '\\<server name>\D$\Program Files\Microsoft SQL
Server\MSSQL\ReplData\ftp\<server name>_EM2_EM2 Proxy
Replication\20020125092210\A Test 9_257.sch' could not be propagated to the
It seems odd that it is trying to access it from the server share even
though this subscription is configured to use ftp. Also note, that is not
even the location of the ftp configured in the publication.
I end up having to reinitialize the client, the synchronize to get the
changes. This is not really acceptable over slow network links.
Is there any way to just get the snaphot of the new article to sync. as is
indicated when I make the change?