469,626 Members | 1,010 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,626 developers. It's quick & easy.

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

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,

Apr 30 '07 #1
1 1190
MC
I would assume that index is fragmented and the record count is not the same
as far as I can see....
MC

<wa*********@yahoo.comwrote in message
news:11**********************@n59g2000hsh.googlegr oups.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,

Apr 30 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

By using this site, you agree to our Privacy Policy and Terms of Use.