Changing alt snapshot folder for merge replication

• triloba

  Mr or Mrs. 500

  Points: 582

  More actions

  September 22, 2015 at 7:41 am

  #311683

  I have a merge replication. Currently works fine. Publisher & Distributor are on the same server. I need to change the location of the alternate folder for the snapshot files.

  I’ll probably just change it through the GUI, but would I use sp_changedistpublisher or sp_changemergepublication if I were scripting everything?

  My real concern is the subscribers. Do I have to ‘tell’ the subscribers where the alt folder has been changed to? Do I just run sp_changemergepullsubscription on the subscribers?

  Thanks,

  Tom

• triloba

  Mr or Mrs. 500

  Points: 582

  More actions

  September 22, 2015 at 10:47 am

  #1828499

  Well, thanks anyway.

  In a test environment, I've changed the publication with sp_changmergepublication, created a new snapshot and then reinitialized the subscriber. Worked fine.

  Tom