0

I am planning to move Replication snapshot folder and Distribution database from C to another drive. Following is what I read blog post.

My setup - Both Distributor and publisher are in same server.

  1. Move distribution DB Step 1 Stop SQL agent Step 2 Move MDF & LDF using alter database command

  2. Change replication snapshot folder

Step 1 USE distribution
exec sp_changedistpublisher @publisher = 'XXX', @property = 'working_directory', @value = '\New share\Share' Step 2 Generate a new snapshot for each publication

Do I need to consider anything further.

Improve this question

0

Reset to default

Your Answer

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

Browse other questions tagged or ask your own question.