• Im surprised there is such a big disparity between backup vs bcp, maybe I just never looked. One idea is to break it up into separate publications, maybe separate pub for each large table, one pub for all small tables. That way the snapshot will go faster and the log won't grow as much. Lot to be said for this approach anyway, you don't want to have to resnapshot everything if just one article out of sync.

    Andy

    http://qa.sqlservercentral.com/columnists/awarren/