O'Reilly logo

Fundamentals of SQL Server 2012 Replication by Sebastian Meine

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 3: The Role of the Distributor

The Distributor is the core component in a SQL Server replication setup. The Distributor controls and executes the processes that move the data from one server to another. SQL Server comes with a set of Windows executables that carry out the processes that make replication work. These programs are called replication agents. In a default setup of replication, most (or potentially all) replication agents run on the Distributor. The Distributor also stores metadata about publications and subscriptions in the distribution database.

Distribution Components

A number of specific components are important to the Distributor and replication in general. They include the distribution database, snapshot folder, and ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required