SQL Server DBA

Replication administration and troubleshooting

Question

Snapshot versus transactional replication: what differs, and when should each be used?

Answer

Snapshot replication republishes a complete copy at synchronization; transactional replication continuously delivers committed changes. Use snapshot for small, infrequently changing datasets; use transactional replication for low-latency incremental distribution.

This is 11 of 25 free samples for SQL Server DBA.

More SQL Server DBA topic samples