Re: Snapshot Replication failing

Tech-Archive recommends: Speed Up your PC by fixing your registry

Try changing it using the GUI. (also, I'd recommend in general, to avoid the
admin shares).
Rgds,
Paul Ibison

"Jason Greene" <JasonGreene@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C49EE4A6-6BD7-4799-84F5-79189F052345@xxxxxxxxxxxxxxxx
>I issued the following command:
>
> sp_changedistpublisher
> 'QA','working_directory','x:\mssql\data\snapshot'
>
> And I got a success reply:
>
> You have updated the Publisher property 'working_directory'
> successfully.
>
> Then I issued the following command:
>
> sp_helpdistributor
>
> And it showed me the directory did not change
> DIRECTORY
> \\MOTORX\e$\MSSQL\ReplData
>
> my E$ share is what is running out of space.. How do I change this?
>
> "Paul Ibison" wrote:
>
>> Jason,
>> issuing
>> sp_changedistpublisher @publisher = 'publisher'
>> , @property = 'working_directory'
>> , @value = 'value'
>>
>> Should do it. Otherwise, right-click the replication monitor. On the
>> publishers tab click on the elipsis button and this gives access to teh
>> snapshot folder.
>>
>> Rgds,
>>
>> Paul Ibison
>>
>>
>>


.

Quantcast