O'Reilly logo

Microsoft SQL Server 2008 High Availability by Hemantgiri S. Goswami

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

Distribution Agent

It is an executable file — distrib.exe. Distribution agent is responsible for moving snapshot and transactions (for Transactional Replication) to the Subscribers.

When we configured replication, it creates an agent and its profiles get created. Generally, an agent profile has a set of parameters, that are queried each time an agent runs and logs into the Distributor. Apart from agents, it creates some maintenance jobs to keep the database synchronized and in shape. Refer to the following screenshot:

Distribution Agent

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