Dear All
I've made transactional replication between two SQL 2005 servers.
Everything looks fine, synchronization working fine, no errors, however size of replicated database file = 97 Mb,
on Publications server the database file size = 184 Mb.
What is wrong :S ?
Best Regards
PiotrMB?
You should be using Access|||Sounds like the equivalent of shrinking to me...|||Sounds like the equivalent of shrinking to me...
It's funny you talk about shrinkage, and your name is George|||The data on the replicated server has been defragmented. behind the scenes, the snapshot bcp's out the data from the publisher, and bcp's it in to the subscriber. This removes any whitespace created by deletes and page splits.|||That's a much more elegant way of putting it...
I had the whole "Ya know when you defrag your PC..." conversation knocking about in my head.
