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

ОБЛАСТЬ ПРИМЕНЕНИЯ: даSQL Server нетБаза данных SQL AzureнетХранилище данных SQL AzureнетParallel Data WarehouseAPPLIES TO: yesSQL Server 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 MSdbmsMSdbms
MSagent_parametersMSagent_parameters MSdbms_datatypeMSdbms_datatype
MSagent_profilesMSagent_profiles MSdbms_datatype_mappingMSdbms_datatype_mapping
MSdistpublishersMSdistpublishers MSdbms_mapMSdbms_map
MSdistributiondbsMSdistributiondbs MSreplmonthresholdmetricsMSreplmonthresholdmetrics
MSdistributorMSdistributor sysreplicationalertssysreplicationalerts
   

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

MSarticlesMSarticles MSrepl_backup_lsnsMSrepl_backup_lsns
MScached_peer_lsnsMScached_peer_lsns MSrepl_commandsMSrepl_commands
MSdistribution_agentsMSdistribution_agents MSrepl_errorsMSrepl_errors
MSdistribution_historyMSdistribution_history MSrepl_identity_rangeMSrepl_identity_range
MSlogreader_agentsMSlogreader_agents MSrepl_originatorsMSrepl_originators
MSlogreader_historyMSlogreader_history MSrepl_transactionsMSrepl_transactions
MSmerge_agentsMSmerge_agents MSrepl_versionMSrepl_version
MSmerge_articlehistoryMSmerge_articlehistory MSreplication_monitordataMSreplication_monitordata
MSmerge_historyMSmerge_history MSsnapshot_agentsMSsnapshot_agents
MSmerge_identity_range_allocationsMSmerge_identity_range_allocations MSsnapshot_historyMSsnapshot_history
MSmerge_sessionsMSmerge_sessions MSsubscriber_infoMSsubscriber_info
MSmerge_subscriptionsMSmerge_subscriptions MSsubscriber_scheduleMSsubscriber_schedule
MSpublication_accessMSpublication_access MSsubscriptionsMSsubscriptions
MSpublicationsMSpublications MSsubscription_propertiesMSsubscription_properties
MSpublicationthresholdsMSpublicationthresholds MSsync_statesMSsync_states
MSpublisher_databasesMSpublisher_databases MStracer_historyMStracer_history
MSqreader_agentsMSqreader_agents MStracer_tokensMStracer_tokens
MSqreader_historyMSqreader_history
   

Эти таблицы в базе данных распространителя используются для репликации данных, отличными от 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_requestMSpeer_request
MSdynamicsnapshotjobsMSdynamicsnapshotjobs MSpeer_responseMSpeer_response
MSdynamicsnapshotviewsMSdynamicsnapshotviews MSpeer_topologyrequestMSpeer_topologyrequest
MSmerge_altsyncpartnersMSmerge_altsyncpartners MSpeer_topologyresponseMSpeer_topologyresponse
MSmerge_conflicts_infoMSmerge_conflicts_info MSpub_identity_rangeMSpub_identity_range
MSmerge_contentsMSmerge_contents MSrepl_identity_rangeMSrepl_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
MSpeer_originatorid_historyMSpeer_originatorid_history
   

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

MSdynamicsnapshotjobsMSdynamicsnapshotjobs MSmerge_tombstoneMSmerge_tombstone
MSdynamicsnapshotviewsMSdynamicsnapshotviews MSpeer_lsnsMSpeer_lsns
MSmerge_altsyncpartnersMSmerge_altsyncpartners MSrepl_identity_rangeMSrepl_identity_range
MSmerge_conflicts_infoMSmerge_conflicts_info MSrepl_queuedtraninfoMSrepl_queuedtraninfo
MSmerge_contentsMSmerge_contents MSreplication_objectsMSreplication_objects
MSmerge_current_partition_mappingsMSmerge_current_partition_mappings MSreplication_subscriptionsMSreplication_subscriptions
MSmerge_dynamic_snapshotsMSmerge_dynamic_snapshots MSsnapshotdeliveryprogressMSsnapshotdeliveryprogress
MSmerge_errorlineageMSmerge_errorlineage MSsubscription_propertiesMSsubscription_properties
MSmerge_generation_partition_mappingsMSmerge_generation_partition_mappings sysmergearticlessysmergearticles
MSmerge_genhistoryMSmerge_genhistory sysmergepartitioninfosysmergepartitioninfo
MSmerge_identity_rangeMSmerge_identity_range sysmergepublicationssysmergepublications
MSmerge_metadataaction_requestMSmerge_metadataaction_request sysmergeschemaarticlessysmergeschemaarticles
MSmerge_partition_groupsMSmerge_partition_groups sysmergeschemachangesysmergeschemachange
MSmerge_past_partition_mappingsMSmerge_past_partition_mappings sysmergesubscriptionssysmergesubscriptions
MSmerge_replinfoMSmerge_replinfo sysmergesubsetfilterssysmergesubsetfilters
MSmerge_settingshistoryMSmerge_settingshistory "systranschemas"systranschemas
   

См. такжеSee Also

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