I have a transactional pull replication running.
The publisher and the distributor are both SQL server 2012. The subscriber is a SQL express 2012.
I have setup the server to get the initial snapshot from a compressed FTP file. The data transfered is already filtered to the minimum required. Those parts work fine.
Where it seems to have a problem is when the subscriber tries to apply the snapshot. On a high bandwidth network, the snapshot is applied in less then one minute. On a low bandwidth network, the snapshot can take up to 20 minutes to apply.
On the 20 minutes, downloading the FTP snapshot from the low bandwidth subscriber takes 2 minutes.After this, applying the decompressed local files is taking the other 18 minutes.
The ftp snapshots are not supposed to be run locally ?
Why applying local file on the local server takes 18 minutes on a low bandwidth network subscriber and only takes few seconds on high bandwidth network subcriber ?
Thanks !