SQL Server 2000 Publisher with MSDE subscribers using Merge Replication.
Our retention period is currently set to the default of 14 days. We would like to reduce this to 10 days or perhaps to 7 days to decrease the metadata being stored in the merge tables.
Can this be done while replicating by simply changing the value or will it require reinitialization for all subscribers? I read that increasing the retention period would lead to non-convergence but I saw no such warnings related to reducing it. It would seem logical that the excess metadata would simply be removed upon next merge agent process for data greater than the new setting(10 days) but I was hoping someone could confirm it's as simple as this.
TIA!
J
Our retention period is currently set to the default of 14 days. We would like to reduce this to 10 days or perhaps to 7 days to decrease the metadata being stored in the merge tables.
Can this be done while replicating by simply changing the value or will it require reinitialization for all subscribers? I read that increasing the retention period would lead to non-convergence but I saw no such warnings related to reducing it. It would seem logical that the excess metadata would simply be removed upon next merge agent process for data greater than the new setting(10 days) but I was hoping someone could confirm it's as simple as this.
TIA!
J