>>At that low bandwidth at the branches, having a connection via Citrix would be the way to go and only have one central server. Trying to replicate over that low bandwidth will be trouble for that data volume potential.
>
>Yes, it turns out the solution provider isn't willing to support replication over low bandwidth, so it's going to have to be some sort of remote access setup.
>
>Embedding documents in the database doesn't happen every day. They might go for a while not doing any, and then have to put in one or two dozen.
>
>Do you have any idea of the efficiency of replication in this sort of scenario? If a 1MB document is embedded, how large of a transaction log entry does that create - I wonder if there's significant bloat.
Just prepare some interesting animation to entertain the user while the 10M document uploads, for the cases when it's coming from a low upload branch office. The speeds you describe sound like what I had last year.