复制表 (Transact-SQL)

项目
12/15/2008

复制系统表支持复制拓扑。如果将用户数据库配置为发布服务器或订阅服务器，则复制会将系统表添加到数据库中。从复制拓扑删除用户数据库时，将删除这些表。有关使用系统表的通用规则，请参阅系统表 (Transact-SQL)。

复制表

下面是复制所使用的系统表的列表，列表按数据库分组。

主数据库中的复制表

MSreplication_options (Transact-SQL)

msdb 数据库中的复制表

MSagentparameterlist	MSdbms_map
MSdbms	MSreplmonthresholdmetrics
MSdbms_datatype	sysreplicationalerts
MSdbms_datatype_mapping

分发数据库中的复制表

MSagent_parameters	MSpublicationthresholds
MSagent_profiles	MSpublisher_databases
MSarticles	MSreplication_objects
MScached_peer_lsns	MSreplication_subscriptions
MSdistpublishers	MSrepl_commands
MSdistribution_agents	MSrepl_errors
MSdistribution_history	MSrepl_originators
MSdistributiondbs	MSrepl_transactions
MSdistributor	MSrepl_version
MSlogreader_agents	MSsnapshot_agents
MSlogreader_history	MSsnapshot_history
MSmerge_agents	MSsubscriber_info
MSmerge_history	MSsubscriber_schedule
MSmerge_sessions	MSsubscriptions
MSmerge_subscriptions	MSsubscription_properties
MSpublication_access	MStracer_history
MSpublications	MStracer_tokens

分发数据库中的这些表用于从非 SQL Server 发布服务器复制数据。有关详细信息，请参阅非 SQL Server 发布服务器。

IHarticles	IHpublishercolumnindexes
IHcolumns	IHpublishercolumns
IHconstrainttypes	IHpublisherconstraints
IHindextypes	IHpublisherindexes
IHindextypes	IHpublishers
IHpublications	IHpublishertables
IHpublishercolumnconstraints	IHsubscriptions

发布数据库中的复制表

MSdynamicsnapshotjobs	MSpeer_request
MSdynamicsnapshotviews	MSpeer_response
MSmerge_altsyncpartners	MSpub_identity_range
MSmerge_conflicts_info	sysarticlecolumns
MSmerge_contents	sysarticles
MSmerge_current_partition_mappings	sysarticleupdates
MSmerge_dynamic_snapshots	sysmergearticlecolumns
MSmerge_errorlineage	sysmergearticles
MSmerge_generation_partition_mappings	sysmergepartitioninfo
MSmerge_genhistory	sysmergepublications
MSmerge_identity_range	sysmergeschemaarticles
MSmerge_metadataaction_request	sysmergeschemachange
MSmerge_partition_groups	sysmergesubscriptions
MSmerge_past_partition_mappings	sysmergesubsetfilters
MSmerge_replinfo	syspublications
MSmerge_settingshistory	sysschemaarticles
MSmerge_tombstone	syssubscriptions
MSpeer_lsns	systranschemas

订阅数据库中的复制表

MSdynamicsnapshotjobs	MSmerge_settingshistory
MSdynamicsnapshotviews	MSmerge_tombstone
MSmerge_altsyncpartners	MSpeer_lsns (Transact-SQL)
MSmerge_conflicts_info	MSrepl_queuedtraninfo
MSmerge_contents	MSsnapshotdeliveryprogress
MSmerge_current_partition_mappings	MSsubscription_properties
MSmerge_dynamic_snapshots	sysmergearticlecolumns
MSmerge_errorlineage	sysmergearticles
MSmerge_generation_partition_mappings	sysmergepartitioninfo
MSmerge_genhistory	sysmergepublications
MSmerge_identity_range	sysmergeschemaarticles
MSmerge_metadataaction_request	sysmergeschemachange
MSmerge_partition_groups	sysmergesubscriptions
MSmerge_past_partition_mappings	sysmergesubsetfilters
MSmerge_replinfo	systranschemas

请参阅

参考

复制视图 (Transact-SQL)

其他资源

How to: Configure Publishing and Distribution (Replication Transact-SQL Programming)
How to: Disable Publishing and Distribution (Replication Transact-SQL Programming)

帮助和信息

获取 SQL Server 2005 帮助