SQL Server replication

The CDC Replication Engine for Microsoft SQL Server requires that you enable Microsoft SQL Server replication in your database to ensure the data required by CDC Replication is available in the database transaction log.

The CDC Replication Engine for Microsoft SQL Server requires the log to contain full before and after images in an UPDATE operation in order to support database recovery; this information is not logged when replication is not enabled in Microsoft SQL server.

CDC Replication supports a local Distribution database (local Distributor) or a remote Distribution database (remote Distributor). If you are using a remote Distribution database, you are required to install CDC Replication on your database server, not the Distribution database server. The CDC Replication Engine for Microsoft SQL Server will configure subscriptions where all data is filtered out; in such cases, no data will end up in the Distribution database.

After enabling SQL Server replication, SQL Server will create jobs that are used exclusively by SQL Server and are not used by CDC Replication. Stopping any of the maintenance jobs may negatively affect SQL Server performance.

If you need more information on how to perform this task, see your database administrator or refer to your Microsoft SQL Server documentation.