Home > Articles > Data > SQL

  • Print
  • + Share This
Like this article? We recommend

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.

  • + Share This
  • 🔖 Save To Your Account