I have merge replication set up between sql mobile and sql 2005 (just recently upgraded from sql 2000). My publication has around 40 published tables, about half of them are filtered. The other day I noticed that the initial replication to get the entire database was downloading the same tables multiple times. The last test was each table was downloaded 10 times. So I did some research which brought me to the following fix, which was to implement dynamic snapshots.
However, when I try to replicate, it generates a dynamic snapshot, but it fails with the following error…
An error occurred while reading the .bcp data file for the 'MSmerge_rowtrack' article. If the .bcp file is corrupt, you must regenerate the snapshot before initializing the Subscriber.(Source: MSSQL_REPL, Error number: MSSQL_REPL-2147199428)
I haven’t changed the snapshot locations, and if I don’t use dynamic snapshots it works fine. I’ve tweaked the permissions (in development) to the point where everyone has full permission on the IIS share, and snapshot folder with no luck.
I would appreciate any advice. Thank you!
Not sure if you'll find an answer here.I've been a part of this thread
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=100529&SiteID=1&PageID=0
without any real resolution so far.
We can re-run the snapshot when it happens and that seems to resolve it for the user who is affected, but if it's a permissoins problem why doesn;t it happen to everyone at once?
No comments:
Post a Comment