Search This Blog

Thursday, January 13, 2011

How to change the replication working directory on the distributor?

By default every publisher stores it snapshot data in the MSSQL7\Repldate folder on the distributor. If you are running out of disk space on that particular you need to change the working directory to another drive. You need to change this path for each publisher, as it is not a global setting on the distributor.

There are two ways to do this:

Method #1:
- Open Enterprise Manager
- Connect to the Distribution server
- Go to Tools -> Replication -> Configure Publishing, Subscribers, and Distribution...
- Go to Publishers tab
- Click on the properties button (...) against the publisher's name
- Enter the new path for the Snapshot folder

Method #2:
Run sp_changedistpublisher from query analyzer. For more information on sp_changedistpublisher see Books Online

No comments:

Post a Comment