 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / General / Other SQL Server Topics / April 2007Replicating 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, I would assume that index is fragmented and the record count is not the same as far as I can see.... MC >I am replicating an 80GB database between NY can CT and would like to > know why table sizes are different between the two. [quoted text clipped - 6 lines] > > Thanks, |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.