The result is what you would expect. The rowcounts match and data space used matches...for the first replication..

If I continue to for replicate it, to mimic the growth of a couple days, I find that the table size grows exponentially. Out of the transaction replication and the snapshot replication only the tables in the snapshot replication have this exponential growth. I DID notice that the snapshot replication is set to delete on the articles rather than drop and create..which leads me to another question:

If I change it to drop and recreate on snapshotted articles will the data space assigned to each article in the subscribing database reset? ie., will my 11 gig table release the unused data space when the table is dropped and recreated during snapshot and return to the size of 103 megs as it should be?

Thanks,

Erin