 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Other Technologies / Replication / March 2006database size
hello all, I have implemented a transactional replication (queued updating) that creates a full replica of the main database. The size of the main db is 15GB and the replicated db's size is 12GB. I would like to know why this difference. thank you, peti Peti, a few questions: are you replicating the complete database? Are you comparing the actual size after taking account of shrinking etc? Are the indexes contiguous? Do you have exactly the same set of indexes? Cheers, Paul Ibison SQL Server MVP, www.replicationanswers.com (recommended sql server 2000 replication book: http://www.nwsu.com/0974973602p.html) Thank you Paul, Sorry for delay. I have some answers for your questions: The complete database is replicated and I shrunk all dbs before to compare. I have the same set of indexes that are fragmented, I supose, because they were never rebuilt. Cheers, peti > Peti, > a few questions: [quoted text clipped - 6 lines] > (recommended sql server 2000 replication book: > http://www.nwsu.com/0974973602p.html) |
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.