2

We have SQL Server 2012 SP2 running on Windows Server 2012.

We need to change the snapshot folder for all (including default) transaction replication publications.

I have read that this means the replication needs to be re-initialized?

Why is the case? If I update table msdb.dbo.MSdistpublishers with the new working_directory then I can't see why the replication should need to be re-initialized?

Any recommendations appreciated.

1 Answer 1

4

You can change in this way

exec sp_changepublication  @publication
@property='snapshot_in_defaultfolder'
@value='0'
@force_invalidate_snapshot=0,--always remmeber that
@force_reinit_subscription=0--always remmeber that

exec sp_changepublication  @publication
@property='alt_snapshot_folder'
@value='C:\your_dir'
@force_invalidate_snapshot=0,--always remmeber that
@force_reinit_subscription=0--always remmeber that
0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.