Contents
What is the difference between transactional replication and snapshot replication?
Snapshot replication and transactional replication use the Distribution Agent to deliver the files, whereas merge replication uses the SQL Server Merge Agent. The Snapshot Agent runs at the Distributor.
What kind of agent does SQL Server snapshot replication use?
The SQL Server Snapshot Agent always generates the snapshot files, but the agent that delivers the files differs depending on the type of replication being used. Snapshot replication and transactional replication use the Distribution Agent to deliver the files, whereas merge replication uses the SQL Server Merge Agent.
How to create and apply a SQL Server snapshot?
By default, it is then applied by the Distribution Agent (for snapshot and transactional replication) or Merge Agent (for merge subscriptions) for all subscriptions. A snapshot can also be generated using SQL Server Management Studio and Replication Monitor.
How to create transactional replication in SQL Server?
For transactional replication, we need to choose a database which contains all other database objects like Table, Views, Stored Procedures, etc. Click Next Select Transactional publication as replication type. Select the Tables, stored procedures which you want to replicate.
What should maxbcpthreads be in replication snapshot agent?
MaxBcpThreads must have a value greater than 0 and has no hard-coded upper limit. The default is twice the number of processors. If the replicated object has a filter, then the Snapshot agent will generate only one BCP file for that article instead of generating multiple BCP files.
How is a snapshot generated for Merge Replication?
For merge replication, a snapshot is generated every time the Snapshot Agent runs. For transactional replication, snapshot generation depends on the setting of the publication property immediate_sync.
Why does merge replication take a whole day?
I reinitialised one of the subscribers to replicate all the data from the publisher but It takes the whole day downloading the snapshot. At the publisher I see the following message:
Why does compressing a snapshot slow down replication?
However, compressing the snapshot requires additional processing by the Snapshot Agent when generating the snapshot files, and by the Distribution Agent or Merge Agent when applying the snapshot files. This may slow down snapshot generation and increase the time it takes to apply a snapshot in some cases.