Replication Agent Objects

Replication Agent creates objects in the primary database to assist with replication tasks.

The Replication Agent objects are automatically created when you invoke the pdb_xlog command with the init keyword. The existing primary database objects can be marked for replication.

For more general information, see the Replication Agent Administration Guide.

There are two variables in Replication Agent database object names:

prefix – represents the one- to three-character string value of the pdb_xlog_prefix parameter (the default is ra_).
xxx – represents an alphanumeric counter, a string of characters that is (or may be) added to a database object name to make that name unique in the database.

The value of the pdb_xlog_prefix parameter is the prefix string used in all Replication Agent object names. The value of the pdb_xlog_prefix_chars parameter is a list of the nonalphanumeric characters allowed in the prefix string specified by pdb_xlog_prefix. This list of allowed characters is database-specific. For example, in Microsoft SQL Server, the only nonalphanumeric characters allowed in a database object name are the $, #, @, and _ characters.

Use the pdb_xlog command to view the names of Replication Agent transaction log components in the primary database.

See the Replication Agent Administration Guide for details on setting up log object names.

Table, Procedures, Marker, and Trigger Objects
The table and procedure objects, marker procedures and marker shadow tables that are considered Replication Agent objects, as well as commands that are considered Replication Agent trigger objects are listed in the Replication Agent Primary Database Guide.

Parent topic: Microsoft SQL Server as Primary Data Server