"SouRa" <SouRa@discussions.microsoft.com> wrote in message
news:E55D33AA-7918-42BC-A2C0-69FC7DBEC327@microsoft.com...
> Hi
>
> After doubling the query timeout in Replication -agent profile, i am
getting
> error message
> 'The process could not perform retention based meta-data clean up in
> database 'Databasename' in one of the databases
> quite often ( i have 50 databases all of them are being Merge replicated)
>
> I have reproduced below row count of MSMERGE_CONTENTS, MSSMERGE_TOMBSTONE
> and MSMERGE_GENHISTORY for last three days. The details given below.
>
> Table Name Rowcount
> 09/16/2005 09/17/2005 09/19/2005
> MSMERGE_CONTENTS 27599 25316 24820
> MSMERGE_GENHISTORY 14738 14050 14100
> MSSMERGE_TOMBSTONE 57764 50026 54186
>
>
> IN all the database which we are monitoring row count has been decreasing
in
> the above tables.
> However in this specific database where we have this meta-deta issue, we
> notice that the table is actually increasing
>
> These tables indexed regularly and checkdb on this database has not
repored
> any errors
>
>
> Any specific reason for this increase of row count. Does it provides any
> other hints
>
> Do we need to monitor any other parameters
>
> pl advise.
>
> Thanks,
> Soura

"Hilary Cotter" wrote:

> Don't be too concerned by this message or the fact that these tables are
> increasing. It just means you have DML on your subscriber.
>
> What version of SQL are your running and what SP? SQL 2000 SP1 and above
> should be cleaning up with every run of the merge agent.
>
> You might also want to look at running sp_mergemetadataretentioncleanup
> manually.
>
> --
> 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
> "SouRa" <SouRa@discussions.microsoft.com> wrote in message
> news:E55D33AA-7918-42BC-A2C0-69FC7DBEC327@microsoft.com...
> > Hi
> >
> > After doubling the query timeout in Replication -agent profile, i am
> getting
> > error message
> > 'The process could not perform retention based meta-data clean up in
> > database 'Databasename' in one of the databases
> > quite often ( i have 50 databases all of them are being Merge replicated)
> >
> > I have reproduced below row count of MSMERGE_CONTENTS, MSSMERGE_TOMBSTONE
> > and MSMERGE_GENHISTORY for last three days. The details given below.
> >
> > Table Name Rowcount
> > 09/16/2005 09/17/2005 09/19/2005
> > MSMERGE_CONTENTS 27599 25316 24820
> > MSMERGE_GENHISTORY 14738 14050 14100
> > MSSMERGE_TOMBSTONE 57764 50026 54186
> >
> >
> > IN all the database which we are monitoring row count has been decreasing
> in
> > the above tables.
> > However in this specific database where we have this meta-deta issue, we
> > notice that the table is actually increasing
> >
> > These tables indexed regularly and checkdb on this database has not
> repored
> > any errors
> >
> >
> > Any specific reason for this increase of row count. Does it provides any
> > other hints
> >
> > Do we need to monitor any other parameters
> >
> > pl advise.
> >
> > Thanks,
> > Soura
>
>