Monitor SQL Server Replication Jobs

The Replication infrastructure in SQL Server is implemented using SQL Server Agent to execute the various components involved in the form of a job (e.g. LogReader agent job, Distribution agent job, Merge agent job) SQL Server jobs execute a binary executable file which is basically C++ code.

Transactional Replication

Peer to Peer Replication

SQL Server Replication: Providing High Availability using Database Mirroring

This white paper describes how to use database mirroring to increase the availability of the replication stream in a transactional environment. The document covers setting up replication in a mirrored environment, the effect of mirroring partnership state changes, and the effect of mirroring failovers on replication. In addition, it describes how to use LSN-based initialization to recover from the failover of a mirrored Subscriber database.

Space Impact of Replication Snapshot Agent Job in SQL Server

I have noticed that available disk space on my SQL Server is getting low and I see a number of files getting generated in the replication snapshot folder. Because of these files there is a space issue on my server. Why are these files here and what can I do to resolve this problem?

Replication DR

Manage and Monitor Identity Ranges in SQL Server Transactional Replication

This article demonstrates how to prevent primary key violation issues in transactional replication.

Controlling Growth of a Distribution Database

This article provides a practical example of minimizing the growth of a distribution database.

Monitoring Transactional Replication – The Distribution Queue

This article looks at the distribution database what information can be obtained for monitoring transactional replication.

Slowly Changing Facts

This article describes a design pattern for storing “effective dated" changes to fact tables.