0

I read an excellent article about copying the snapshot files for Transactional replication from Publisher to Subscriber and Apply them on subscriber.

http://blogs.msdn.com/b/repltalk/archive/2010/03/07/tips-to-improve-performance-when-applying-snapshot-in-transactional-replication.aspx

But the focus of this article is directed to Transactional Replication.

I want to know how we can copy the snapshots from publisher, paste them on the subscriber and apply them on subscriber. I am using Merge Replication with push subscriber, Distributor and Publisher are on the same server.

Thakur
  • 1,890
  • 5
  • 23
  • 33

1 Answers1

3

Yes - With Merge we can copy the snapshot files to the Subscriber and apply the snapshot locally using the Merge Agent -AltSnapshotFolder parameter.

Brandon Williams
  • 3,695
  • 16
  • 19
  • I really appreciate this answer, but can you please elaborate a bit the steps that should be followed to apply snapshot locally in a merge replication? – Thakur Apr 23 '12 at 18:36
  • 1
    The steps are: 1) Generate the snapshot on the Publisher. 2) Copy the snapshot folder to the Subscriber. 3) Start the Merge Agent using the -AltSnapshotFolder parameter specifying the path to the local snapshot. – Brandon Williams Apr 23 '12 at 20:40
  • 1
    Here is the perfect answer - http://social.msdn.microsoft.com/Forums/en/sqlreplication/thread/d27ace11-a891-4000-8698-25044685bf3f?prof=required – Thakur Apr 23 '12 at 21:33