Change the snapshot location of all publication
You can change the snapshot location without having to perform a re-initialization.
The only caveat to this is you do need to generate a new snapshot. This snapshot will not be applied to your subscribers,
but has to go through the generation process. I recommend doing this at night or weekends
to minimize the impact of the snapshot agent locking tables and contention on the publisher database.
Change snapshot location for all publication
/*Change path will generate new snapshot BCP file in the new location but this will not apply into subscription*/
USE distribution
exec sp_changedistpublisher
@publisher = ‘Node1’,
@property = ‘working_directory’,
@value = ‘\\NODE1\New_Repl_Snap_1’
For more:
https://www.mssqltips.com/sqlservertip/2785/changing-sql-servers-default-snapshot-folder-for-replication/
