在分发服务器上查看信息

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之前无法被分发清除作业清除.