How can I force a subscriber to be synchronized from a local snapshot?

Posted by Brian on Stack Overflow See other posts from Stack Overflow or by Brian
Published on 2010-04-22T14:20:49Z Indexed on 2010/04/22 14:23 UTC
Read the original article Hit count: 204

Filed under:
|
|
|

Hello,

I have a SQL 2005 server replicating(merge\push) to SQL 2005 and SQL 2000 servers. I have multiple subscribers spread througout the United states. I have set , @snapshot_in_defaultfolder = N'false', @alt_snapshot_folder = N'c:\snapshots\Merge\' (sample location). I take the snapshot from the publisher that is in the same location, 'c:\snapshots\Merge\', and copy it to the subscribers. I wanted to avoid applying the snapshot over the WAN but from the performance I am getting the synchronization is going over the WAN. Does anybody have any ideas how to make sure that I am using the local copy of the snapshot and not the copy at the publisher? Thanks

© Stack Overflow or respective owner

Related posts about sql

Related posts about replication