RE: INCREMENT IN DATAFILE SIZE

Tech-Archive recommends: Fix windows errors by optimizing your registry

There could be any number of reasons for the difference in size. Are there
objects on the publisher that aren't being replicated to the subscriber, and
vice versa?

Do you have different indexes on the remote server, versus the one that is
1.50 gb? Is the fill factor different? Have you confirmed all the data is
in sync on the tables that are actually being replicated? Are you doing
filtering on the subscriptions? Are there triggers on the subscriber that
don't exist on the publisher?
Have you run dbcc checkdb on your db's? If not, give it a shot and make
sure we don't have any corruption.

Run a count (*) on the same table on the publisher and the subscriber. Do
they return the same number of rows? Or at least close to the same number of
rows including what might currently be in the process of replicating.

I was surfing and found a utility called SQLDiff from ApexSQL.com. I have
NO affiliation with them, and I haven't ever used their product, but they
have a trial version. It compares two databases completely. Might be
something to look into. Like I said...no affiliation!

You are going to have to do some detective work! :-)
Donna



"SouRa" wrote:

> Hi,
>
> I am dealing with 15 databases, all are merge replicated with remote
> server(publisher).
> Daily, the Datafile size is noted. For a particular database, from
> 04/01/2005 to 04/22/2005 the datafile size 1.37 GB. But on 04/23/2005 it is
> increased to 1.50 GB
>
> The DB property : Automatically grow file
> By percent : 10
> But in remote server it is same as 1.24 GB
>
> What are all the reason for this(growth of datafile size)?
> Is there implication due to this?
>
> Thanks,
> Soura
>
>
>
>
.

Relevant Pages

  • Is Ok to clean msmerg_genhistory at publisher and not subscriber?
    ... Is Ok to clean msmerg_genhistory at publisher and not subscriber? ... have a lot of subscribers merge replicating their data to a central ... server. ...
    (microsoft.public.sqlserver.replication)
  • Re: sp_repladdcolumn on Indexed View
    ... Whats a Custom Sync Object? ... >to a subscriber where the schemas are different. ... >the table on the publisher and have them replicated to ... But say Im replicating ...
    (microsoft.public.sqlserver.replication)
  • Merge replication issue - one column not replicating
    ... We're running merge replication between to SQL Server 2000 servers. ... We have a push subscription set up and we seem to replicating data ... When we update a particular int column at the publisher, ... won't propogate to the subscriber. ...
    (comp.databases.ms-sqlserver)
  • Re: sp_repladdcolumn on Indexed View
    ... There are two options when you are replicating to an object on the publisher ... to a subscriber where the schemas are different. ... "ChrisR" wrote in message ...
    (microsoft.public.sqlserver.replication)
  • Re: Replicated Database Not In Sync - How to ensure whole database is in sync
    ... there are a few reasons I have come across for non-convergence: ... If a change from publisher fails to get applied at the subscriber (for some ...
    (microsoft.public.sqlserver.replication)