>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.

Sorry, but my experience here is lacking. I have always stored the documents external to the database into a protected folder location. If you are concerned with security, then you could store the documents into a password protected zip file with the password stored encrypted into the database with the file name (the file location is a configuration parameter for me).