Troubleshooting Errors
Earlier in this article, you saw how to examine replication errors with the Enterprise Manager. To troubleshoot errors effectively, you should also become familiar with the tables and stored procedures included with the distribution database.
The following table describes some of the tables used with transactional replication in the distribution database:
Replication Related Table Name |
Description |
Msrepl_errors |
Contains rows with extended Distribution agent failure information. |
MSLogreader_history |
Contains history rows for the Log Reader agents associated with the local distributor. This table is queried for populating the Agent History screen within Enterprise Manager. |
MSLogreader_agents |
Contains one row for each Log Reader agent running at the local distributor. |
MSSubscriber_info |
Contains one row for each publisher/subscriber pair that is being pushed subscriptions from the local distributor. |
MSSubscriber_schedule |
Contains default transactional synchronization schedules for each publisher/subscriber pair. |
MSSubscriptions |
Contains one row for each subscription served by the local distributor. |
MSSnapshot_history |
Contains history rows for the Snapshot agents associated with the local distributor. |
MSSnapshot_agents |
Contains one row for each Snapshot agent associated with the local distributor. |
MSPublications |
Contains one row for each publication that is replicated by a publisher. |
MSPublication_access |
Contains a row for each Microsoft SQL Server login that has access to the specific publication or publisher. |
MSRepl_transactions |
Contains identifier and sequence number for each replicated transaction. |
MSArticles |
Contains one row for each article being replicated by a publisher. |
MSPublisher_databases |
Contains one row for each publisher/publisher database pair serviced by the local distributor. |
MSRepl_originators |
Contains one row for each updatable subscriber from which the transaction originated. |
MSRepl_commands |
Contains rows of replicated commands in binary format. |
MSDistribution_history |
Contains history rows for the Distribution agents associated with the local distributor. |
In addition to these tables, replication can create additional tables in each publisher and subscriber database. These tables vary depending on type of replication you use.