SQL Merge Replication - 2x Identical Schema DB with different data - HELP!

Question

SQL Merge Replication - 2x Identical Schema DB with different data - HELP!

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Grant Fritchey SSC Guru Points: 399330 More actions · Answer 1

My replication knowledge is OOOOLLLLLDDDD, like dinosaurs, so take anything else I say with a giant grain of salt.

The errors look like permissions issues. The error itself is saying that it can't move the files around, which implies networks, but I believe that one or more of the services in question don't have the access to the file shares that will make this work. At least, that's where I would start.

I'll see if I can't get some better help in here.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Brandie Tarvin SSC Guru Points: 173108 More actions · Answer 2

Can you download and post the log?

I did a quick google and found some previous versions of SQL Server with a similar error & answers. Hopefully this will help:

https://www.sqlservercentral.com/forums/topic/merge-replication-across-internet-the-merge-process-was-unable-to-deliver-the-snapshot-to-the-subscriber

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/13666ec8-9c4b-4fe4-8ccc-114277373033/the-merge-process-was-unable-to-deliver-the-snapshot-to-the-subscriber-if-using-web?forum=sqlreplication

Also, a quick question. Is there a business need to use replication for this? Or is it just your preference?

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.