Table name |
Description |
MSagent_parameters |
The table contains the parameters associated with the proxy configuration file. The parameter name is the same as the name supported by the proxy. The table is stored in the msdb database. |
MSagent_profiles |
The replication agent configuration file for each definition corresponds to a row in the MSagent_profiles table. The table is stored in the msdb database. |
MSarticles |
Each item replicated by the publisher corresponds to a row in the MSarticles table. This table is stored in the distribution database. |
Mscached_peer_lsns |
The table is used to track LSN values in the transaction log, which are used to determine the commands to be returned to a given subscriber in peer replication. This table is stored in the distribution database. |
Msdistpublishers |
Each remote publisher supported by the local distributor corresponds to a row in the Msdistpublishers table. The table is stored in the msdb database. |
Msdistribution_agents |
A row for each Distribution Agent running on the local distributor in the table. This table is stored in the distribution database. |
MSdistribution_history |
The table contains the history rows for the Distribution Agent associated with the local distributor. This table is stored in the distribution database. |
MSdistributiondbs |
A row for each distribution database defined on the local distributor in the table. The table is stored in the msdb database. |
MSdistributor |
The table contains the properties of the Distributor. The table is stored in the msdb database. |
MSlogreader_agents |
Each Log Reader Agent that runs on the local distributor corresponds to a row in the MSlogreader_agents table. This table is stored in the distribution database. |
Mslogreader_history |
The table contains the history rows for the Log Reader Agent associated with the local distributor. This table is stored in the distribution database. |
MSmerge_agents |
A row for each Merge Agent that runs at the Subscriber in the table. This table is stored in the distribution database. |
MSmerge_history |
The table contains a detailed description of the history row, which includes the results of the previous Merge Agent job session. Each row of the proxy output corresponds to a row in the table. This table is used in the distribution database and in each subscription database. In the distribution database, the table contains the history of all merge publications and subscriptions that use the Distributor. In each subscription database, the table contains a history of the publications that subscribed to the subscriber alignment. |
Msmerge_sessions |
The table contains the history rows, which have the results of the previous Merge Agent job session. Each time the Merge Agent is run, a new row is added to the table. This table is stored in the distribution database. |
MSmerge_subscriptions |
Each subscription that is serviced by the Merge Agent at the Subscriber corresponds to a row in the MSmerge_subscriptions table. This table is stored in the distribution database. |
MSpublication_access |
Each Microsoft SQL server login that has access to a specific publication or publisher has a row in the MSpublication_access table. This table is stored in the distribution database. |
Mspublications |
Table, one row for each publication replicated by the publisher. This table is stored in the distribution database. |
Mspublicationthresholds |
Tables are used to track replication performance hops for a publication, and each monitored threshold corresponds to a row in the table. This table is stored in the distribution database. |
MSpublisher_databases |
each publisher that is serviced by a local distribution server / the publisher database is mspublisher_databases the table occupies a row. This table is stored in the distribution database. |
MSreplication_objects |
Each object associated with replication in the Subscriber database corresponds to a row in the MSreplication_objects table. The table is stored in the subscription database. |
MSreplication_subscriptions |
Table provides one-line replication information for each Distribution Agent that serves the local subscriber database. The table is stored in the subscription database. |
MSrepl_commands |
The table contains the copy command line. The table is stored in the distribution database. |
MSrepl_errors |
The table contains rows with extended Distribution Agent and Merge Agent failure information. This table is stored in the distribution database. |
MSrepl_originators |
Each updatable subscriber that initiates a transaction corresponds to a row in the MSrepl_originators table. This table is stored in the distribution database. |
MSrepl_transactions |
One row for each duplicate transaction in the table. This table is stored in the distribution database. |
Msrepl_version |
In the Msrepl_version table, there is a row for the current version of the copy that is installed. This table is stored in the distribution database. |
Mssnapshot_agents |
A row for each Snapshot Agent associated with the local distributor in the table. This table is stored in the distribution database. |
MSsnapshot_history |
The table contains the history rows for the Snapshot Agent associated with the local distributor. The table is stored in the distribution database. |
MSsubscriber_info |
Each pair of publishers/subscribers that are pushing subscriptions from the local distributor takes one row in the MSsubscriber_info table. This table is stored in the distribution database. |
Mssubscriber_schedule |
The table contains the default merge and transaction synchronization schedules for each Publisher/Subscriber. This table is stored in the distribution database. |
MSsubscriptions |
A row in the MSsubscriptions table for each published item in a subscription that is serviced by a local distributor. This table is stored in the distribution database. |
MSsubscription_properties |
The table contains rows that run the parameter information required by the replication agent at the Subscriber. For pull subscriptions, the table is stored at the subscriber's subscription database, and for push subscriptions, the table is stored in the distribution database of the Distributor. |
MStracer_history |
Table maintains a record of all tracer tokens that the Subscriber has received. This table is stored in the distribution database, and the replication process uses this table to monitor performance. |
MStracer_tokens |
The table maintains a record of the tracking token records that are inserted into the publication. This table is stored in the distribution database, and the replication process uses this table to monitor performance. |