Re: Replication on MSDE2000 and db size problem

Tech-Archive recommends: Speed Up your PC by fixing your registry

1) data type for table is: int, smallint, int, char(11), smallint, smallint,
binary(2001), bit, datetime, int

2) All data is replicating, I can see it on reports on each machines. From
sp_spaceused report I see almost 1GB of unused space.

I know only one workaround:
dbcc dbreindex (..... + shrink db - a few cycles makes db to similar
backup db size.

At the moment system is working on backup PC without problem and new data is
refreshed to publisher.


Janek

"Hilary Cotter" wrote:

A couple of points 1) are you using text in row?
2) Are you sure the data in this column is the same on the publisher and
subscriber. Depending on how you update your text or image data it may not
be replicated.

--
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



"Janek" <Janek@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:456DC0D6-FEDC-43BF-8A22-B6CE22069464@xxxxxxxxxxxxxxxx
Hi,

We have following scenario:

2 PC on WinXP + MSDE2000 + SP4 with production db. Secondary PC works as
failover backup. DBs are connected by merge replication where backup is as
subscriber.

The problem is related to one table with binary column (2K) and its
growing
size (over 100MB per day).

sp_spaceused product_map

name rows reserved data index_size
unused
Product_map 24238 1056648KB 130448KB 13520KB 912640KB

It seems that on insert rows server allocates more space than need. This
problem occures only when system works on publisher db. It is ok when I
switch it to backup PC.

I have the same systems on W2k + MSDE2000 + SP3a + merge replication and
don't observe the problem like this.

could you help me how to diagnose it more deeply and solve the problem?

Janek



.

Relevant Pages

  • Re: Event id 2042 /2041 (Directory service) + 12292/11 (VSS)
    ... on all DC's except FSMO role holder and then promote one DC. ... take system state backup or even any file backup using it. ... Error returned while creating the volume shadow copy:0x8004230f. ... created by loss of replication. ...
    (microsoft.public.windows.server.active_directory)
  • Re: Replicating Windows Server 2003 to create remote backup server
    ... changes, as you can with any replication, but in your case that does not ... So, if we had a replica server, for backup ... Each of those services needs a recovery plan, ...
    (microsoft.public.windows.server.general)
  • Re: continuous backup solution for FreeBSD
    ... I was talking about a reliable backup solution whereas you guys are all the time talking about mirroring and replication type solutions. ... Database replication for both MySQL and PostgreSQL is relatively straight forward. ...
    (freebsd-hackers)
  • Re: continuous backup solution for FreeBSD
    ... I didnt see anywhere that it will replace backup programs? ... a database indexed by a B+ tree of radix 64. ... replication for both MySQL and PostgreSQL is relatively straight forward. ... you think replication is a backup solution, ...
    (freebsd-hackers)
  • Re: disabling adam replication
    ... A backup of the instance will "snapshot" it in that time. ... >>> repadmin /options ADAMserver:ADAMport ... >>>> replication switch. ... >>>>> Lee Flight ...
    (microsoft.public.windows.server.active_directory)