changing merge replication retention period

• Jim C-203340

  SSCommitted

  Points: 1716

  More actions

  April 17, 2008 at 8:42 am

  #189444

  Hi All,

  I am trying to change our retention period for our merge publications. It was set at the default of 14. I'd like to go to 2 days. I changed all 3 of our publications with the following commands.

  sp_changemergepublication @publication='PUB1', @property ='retention', @value ='2';

  GO

  sp_changemergepublication @publication='PUB2', @property ='retention', @value ='2';

  GO

  sp_changemergepublication @publication='PUB3', @property ='retention', @value ='2';

  Everything i have read indicates that when the merge agent runs next, it will purge data from msmerge_contents that is older that 2 days (+24 hours).

  gettting a count of the rows in msmerge_contents (SELECT COUNT(*) FROM MSMERGE_CONTENTS), i see no decrease in the number of rows after running these commands and making sure the merge agent ran.

  I also have read that no snapshot or subscription re-initialization s required after this change. Does anyone know why we would not be seeing purging of the merge meta data when i make this change?

  Regards, Jim C