Tag: AltSnapshotFolder

The Difference between alt_snapshot_folder and AltSnapshotFolder

Sometimes MS SQL Replication developers use similar names for similar meaning but which can have very different results.  These settings both specify alternate location for the Snapshot files, however, one is set at the publication and one at an individual subscriber. alt_snapshot_folder The alt_snapshot_folder parameter is set at the Publisher for ALL subscribers.  This can
Read More »

Tips to improve performance when applying Snapshot in Transactional Replication

1) MaxBCPThreads (contributed by Sanjaya Padhi, Microsoft SQL Server Support) I found we can add in the below point to increase the perf of the snapshot application by the distribution agent by use of MaxBCPThreads parameter as mentioned in the article below.  Please note this does not apply when Snapshot created using default “concurrent” option.
Read More »