Chapter 27 -- Transactional Replication

3 4

Chapter 27

Chapter 26 provided an overview of Microsoft SQL Server 2000 replication, including a brief description of transactional replication. This chapter continues that discussion by providing a detailed examination of transactional replication. It explains how this replication method works, when it should be used, and how to configure, monitor, and tune transactional replication systems.

Transactional replication is probably the most popular replication method. It allows updates to be sent to subscribers fairly quickly after they are applied to publishers, and it does this without requiring high overhead on publishers.