How Replication Agent Works

A Replication Agent is a Replication Server client that retrieves information from a primary database transaction log and formats it for the primary Replication Server.

Begin by marking for replication the desired primary tables and stored procedures in the Replication Agent.

A Replication Agent:
  1. Logs in to the Replication Server.

  2. Sends a connect source command to identify the session as a log transfer source and to specify the database for which transaction information will be transferred.

  3. Retrieves the name of the maintenance user for the database from the Replication Server.

  4. Requests the secondary truncation point for the database from the Replication Server.

  5. Retrieves records from the transaction log, beginning at the record following the secondary truncation point, and formats the information into Log Transfer Language (LTL) commands.