Yes it will take effect immediately. This value is used by the distribution
cleanup agent to clean up the records, the next time the agent runs it will
use the new value and do the cleanup accordingly.
If you look at the job properties of the distribution clean up job you will
see that we execute sp_MSdistribution_cleanup with the least and max
retention as parameters.
If you check the value for max before you make the change you will see that
it is 72
and if you check it after you make the change it should be 336
[quoted text, click to view] "SQL Replication Guy" wrote:
> I have transaction retention period set to default 72hrs on distribution agent.
>
> I would like to increase it from 72 hrs to 336 hrs.
>
> Will this change comes into effect immediately..??? Will this increase in
> retention period applies to transactions that are already in distributoion
> but not yest applied on subscriber...???
>
Make sure you also change the history retention to 336 hours as well. A
subscription expires when the lesser of the history retention or the
transaction retention period passes.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com "SQL Replication Guy" <SQLReplicationGuy@discussions.microsoft.com> wrote in
message news:E7834EA3-7C24-45E4-8826-61CE288D4AAB@microsoft.com...
[quoted text, click to view] >I have transaction retention period set to default 72hrs on distribution
>agent.
>
> I would like to increase it from 72 hrs to 336 hrs.
>
> Will this change comes into effect immediately..??? Will this increase in
> retention period applies to transactions that are already in distributoion
> but not yest applied on subscriber...???
>
> Any advise..???
