Post reply

Changing alt snapshot folder for merge replication

  • 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

  • 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

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

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