Replicating database btw two sites why aren"t the tables identical in size?

Replicating database btw two sites why aren"t the tables identical in size?

am 30.04.2007 16:43:38 von war_wheelan

I am replicating an 80GB database between NY can CT and would like to
know why table sizes are different between the two.

Here is an example of sp_spaceused::
NY IOI_2007_04_23 rows(279,664) reserved(464,832)
data(439,960) index_size(24,624)
CT IOI_2007_04_23 rows(279,666) reserved(542,232)
data(493,232) index_size(48,784)

Thanks,

Re: Replicating database btw two sites why aren"t the tables identical in size?

am 30.04.2007 21:11:45 von MC

I would assume that index is fragmented and the record count is not the same
as far as I can see....


MC

wrote in message
news:1177944218.213649.294530@n59g2000hsh.googlegroups.com.. .
>I am replicating an 80GB database between NY can CT and would like to
> know why table sizes are different between the two.
>
> Here is an example of sp_spaceused::
> NY IOI_2007_04_23 rows(279,664) reserved(464,832)
> data(439,960) index_size(24,624)
> CT IOI_2007_04_23 rows(279,666) reserved(542,232)
> data(493,232) index_size(48,784)
>
> Thanks,
>