在分发服务器上查看信息
1 发布信息
use [distribution]
select publication,publication_id,publisher_db, case publication_type
when 0 then 'transactional'
when 1 then 'snapshot'
when 2 then 'merge'
end as publication_type ,
allow_anonymous, case sync_method
when 0 then 'native'
when 1 then 'character'
when 3 then 'concurrent'
when 4 then 'concurrent_c'
end as publication_type ,
allow_initialize_from_backup
From MSpublications
2 查看Agent的profile信息, 每个agent都有相应的系统表可以供查看:
select *From MSsnapshot_agents
select *From MSdistribution_agents
select *From MSlogreader_agents
上面的查询会返回正在应用的profileid,将返回的profileid赋值sp_help_agent_parameter.
我们以logReader agent为例
select *From MSlogreader_agents
exec sp_help_agent_parameter @profile_id=17
3 查看是否存在匿名订阅(allow_anonymous)或立即初始化(immediate_sync)选项
select * from MSsubscriptions where subscriber_id < 0
这两个选项会导致msrepl_transactions和msrepl_commands表的内容在到达max retention之前无法被分发清除作业清除.