Таблицы репликации (Transact-SQL)Replication Tables (Transact-SQL)

ОБЛАСТЬ ПРИМЕНЕНИЯ: даSQL Server (начиная с версии 2012) нетБаза данных SQL Azure нетХранилище данных SQL AzureнетParallel Data Warehouse APPLIES TO: yesSQL Server (starting with 2012) noAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

Топология репликации поддерживается с помощью системных таблиц репликации.A replication topology is supported by replication system tables. При конфигурации пользовательской базы данных в качестве издателя или подписчика в ходе репликации в базу данных добавляются системные таблицы.When a user database is configured as a Publisher or a Subscriber, replication adds system tables to the database. При удалении пользовательской базы данных из топологии репликации эти таблицы удаляются.These tables are removed when a user database is removed from a replication topology. Общие правила в отношении использования системных таблиц см. в разделе системные таблицы (Transact-SQL).For general rules regarding using system tables, see System Tables (Transact-SQL).

Таблицы репликацииReplication Tables

Ниже приведен список системных таблиц, используемых при репликации и сгруппированных по базам данных.The following is a list of the system tables used by replication, grouped by database.

Таблицы репликации в базе данных masterReplication Tables in the master Database

MSreplication_options (Transact-SQL)MSreplication_options (Transact-SQL)

Таблицы репликации в базе данных msdbReplication Tables in the msdb Database

MSagentparameterlistMSagentparameterlist MSdbms_mapMSdbms_map
MSdbmsMSdbms MSreplmonthresholdmetricsMSreplmonthresholdmetrics
MSdbms_datatypeMSdbms_datatype sysreplicationalertssysreplicationalerts
MSdbms_datatype_mappingMSdbms_datatype_mapping

Таблицы репликации в базе данных распространителяReplication Tables in the Distribution Database

MSagent_parametersMSagent_parameters MSpublicationthresholdsMSpublicationthresholds
MSagent_profilesMSagent_profiles MSpublisher_databasesMSpublisher_databases
MSarticlesMSarticles MSreplication_objectsMSreplication_objects
MScached_peer_lsnsMScached_peer_lsns MSreplication_subscriptionsMSreplication_subscriptions
MSdistpublishersMSdistpublishers MSrepl_commandsMSrepl_commands
MSdistribution_agentsMSdistribution_agents MSrepl_errorsMSrepl_errors
MSdistribution_historyMSdistribution_history MSrepl_originatorsMSrepl_originators
MSdistributiondbsMSdistributiondbs MSrepl_transactionsMSrepl_transactions
MSdistributorMSdistributor MSrepl_versionMSrepl_version
MSlogreader_agentsMSlogreader_agents MSsnapshot_agentsMSsnapshot_agents
MSlogreader_historyMSlogreader_history MSsnapshot_historyMSsnapshot_history
MSmerge_agentsMSmerge_agents MSsubscriber_infoMSsubscriber_info
MSmerge_historyMSmerge_history MSsubscriber_scheduleMSsubscriber_schedule
MSmerge_sessionsMSmerge_sessions MSsubscriptionsMSsubscriptions
MSmerge_subscriptionsMSmerge_subscriptions MSsubscription_propertiesMSsubscription_properties
MSpublication_accessMSpublication_access MStracer_historyMStracer_history
MSpublicationsMSpublications MStracer_tokensMStracer_tokens

Эти таблицы в базе данных распространителя используются для репликации данных, отличными от SQL ServerSQL Server издателя.These tables in the distribution database are used for replicating data from non- SQL ServerSQL Server Publisher. Дополнительные сведения см. в разделе издателей, не SQL Server.For more information, see Non-SQL Server Publishers.

IHarticlesIHarticles IHpublishercolumnindexesIHpublishercolumnindexes
IHcolumnsIHcolumns IHpublishercolumnsIHpublishercolumns
IHconstrainttypesIHconstrainttypes IHpublisherconstraintsIHpublisherconstraints
IHindextypesIHindextypes IHpublisherindexesIHpublisherindexes
IHindextypesIHindextypes IHpublishersIHpublishers
IHpublicationsIHpublications IHpublishertablesIHpublishertables
IHpublishercolumnconstraintsIHpublishercolumnconstraints IHsubscriptionsIHsubscriptions

Таблицы репликации в базе данных публикацииReplication Tables in the Publication Database

conflict_<схема > <таблицы >conflict<schema>_<table> MSpeer_originatorid_historyMSpeer_originatorid_history
MSdynamicsnapshotjobsMSdynamicsnapshotjobs MSpeer_topologyrequestMSpeer_topologyrequest
MSdynamicsnapshotviewsMSdynamicsnapshotviews MSpeer_topologyresponseMSpeer_topologyresponse
MSmerge_altsyncpartnersMSmerge_altsyncpartners MSpeer_requestMSpeer_request
MSmerge_conflicts_infoMSmerge_conflicts_info MSpeer_responseMSpeer_response
MSmerge_contentsMSmerge_contents MSpub_identity_rangeMSpub_identity_range
MSmerge_current_partition_mappingsMSmerge_current_partition_mappings sysarticlecolumnssysarticlecolumns
MSmerge_dynamic_snapshotsMSmerge_dynamic_snapshots sysarticlessysarticles
MSmerge_errorlineageMSmerge_errorlineage sysarticleupdatessysarticleupdates
MSmerge_generation_partition_mappingsMSmerge_generation_partition_mappings sysmergearticlecolumnssysmergearticlecolumns
MSmerge_genhistoryMSmerge_genhistory sysmergearticlessysmergearticles
MSmerge_identity_rangeMSmerge_identity_range sysmergepartitioninfosysmergepartitioninfo
MSmerge_metadataaction_requestMSmerge_metadataaction_request sysmergepublicationssysmergepublications
MSmerge_partition_groupsMSmerge_partition_groups sysmergeschemaarticlessysmergeschemaarticles
MSmerge_past_partition_mappingsMSmerge_past_partition_mappings sysmergeschemachangesysmergeschemachange
MSmerge_replinfoMSmerge_replinfo sysmergesubscriptionssysmergesubscriptions
MSmerge_settingshistoryMSmerge_settingshistory sysmergesubsetfilterssysmergesubsetfilters
MSmerge_tombstoneMSmerge_tombstone syspublicationssyspublications
MSpeer_conflictdetectionconfigrequestMSpeer_conflictdetectionconfigrequest sysschemaarticlessysschemaarticles
MSpeer_conflictdetectionconfigresponseMSpeer_conflictdetectionconfigresponse syssubscriptionssyssubscriptions
MSpeer_lsnsMSpeer_lsns "systranschemas"systranschemas

Таблицы репликации в базе данных подпискиReplication Tables in the Subscription Database

MSdynamicsnapshotjobsMSdynamicsnapshotjobs MSmerge_settingshistoryMSmerge_settingshistory
MSdynamicsnapshotviewsMSdynamicsnapshotviews MSmerge_tombstoneMSmerge_tombstone
MSmerge_altsyncpartnersMSmerge_altsyncpartners MSpeer_lsns (Transact-SQL)MSpeer_lsns (Transact-SQL)
MSmerge_conflicts_infoMSmerge_conflicts_info MSrepl_queuedtraninfoMSrepl_queuedtraninfo
MSmerge_contentsMSmerge_contents MSsnapshotdeliveryprogressMSsnapshotdeliveryprogress
MSmerge_current_partition_mappingsMSmerge_current_partition_mappings MSsubscription_propertiesMSsubscription_properties
MSmerge_dynamic_snapshotsMSmerge_dynamic_snapshots sysmergearticlecolumnssysmergearticlecolumns
MSmerge_errorlineageMSmerge_errorlineage sysmergearticlessysmergearticles
MSmerge_generation_partition_mappingsMSmerge_generation_partition_mappings sysmergepartitioninfosysmergepartitioninfo
MSmerge_genhistoryMSmerge_genhistory sysmergepublicationssysmergepublications
MSmerge_identity_rangeMSmerge_identity_range sysmergeschemaarticlessysmergeschemaarticles
MSmerge_metadataaction_requestMSmerge_metadataaction_request sysmergeschemachangesysmergeschemachange
MSmerge_partition_groupsMSmerge_partition_groups sysmergesubscriptionssysmergesubscriptions
MSmerge_past_partition_mappingsMSmerge_past_partition_mappings sysmergesubsetfilterssysmergesubsetfilters
MSmerge_replinfoMSmerge_replinfo "systranschemas"systranschemas

См. такжеSee Also

Настройка публикации и распространения Configure Publishing and Distribution
Disable Publishing and Distribution (Отключение публикации и распространения)Disable Publishing and Distribution
Представления репликации (Transact-SQL)Replication Views (Transact-SQL)