"Natasja" <Natasja@discussions.microsoft.com> wrote in message
news:5EBF502D-477C-4869-8AA9-2C513AD4A85B@microsoft.com...
> Hi,
>
> I have a sql server 2000 SP4 publisher and a sql server MSDE SP4
> subscriber.
> After applying the initial snaphot I can see the inserted record
> information
> remains in the msmerge_contents table. Is this normal behaviour? Is there
> a
> way to prevent this. Our database is approximately 800MB at the publisher,
> but since so much metadata is retained at the subscriber the subscription
> database is about 1,5GB in size. This is becoming a problem, after a few
> synchronizations our subscription database reaches the 2GB MSDE limit. Is
> there any way of solving this besides lowering the retention period?
> Is this behaviour different in SQL Server 2005?
> --
> Natasja

"Hilary Cotter" wrote:

> Isn't there a 4 Gig limit and not a 2 Gig limit.
>
> I suggest you drop your retention period from the default of 14 days to
> perhaps 3-5 days.
>
> --
> RelevantNoise.com - dedicated to mining blogs for business intelligence.
>
> 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
> "Natasja" <Natasja@discussions.microsoft.com> wrote in message
> news:5EBF502D-477C-4869-8AA9-2C513AD4A85B@microsoft.com...
> > Hi,
> >
> > I have a sql server 2000 SP4 publisher and a sql server MSDE SP4
> > subscriber.
> > After applying the initial snaphot I can see the inserted record
> > information
> > remains in the msmerge_contents table. Is this normal behaviour? Is there
> > a
> > way to prevent this. Our database is approximately 800MB at the publisher,
> > but since so much metadata is retained at the subscriber the subscription
> > database is about 1,5GB in size. This is becoming a problem, after a few
> > synchronizations our subscription database reaches the 2GB MSDE limit. Is
> > there any way of solving this besides lowering the retention period?
> > Is this behaviour different in SQL Server 2005?
> > --
> > Natasja
>
>