Sqlserver——日常维护——查看发布订阅的日志复制记录和快照复制记录

在 分发数据库 中执行代码：

---查看事务传送记录
SELECT dis_his.agent_id AS [代理ID],
       CASE dis_his.runstatus WHEN 1 THEN N'开始' WHEN 2 THEN N'成功' WHEN 3 THEN N'正在进行' WHEN 4 THEN N'空闲' WHEN N'5' THEN N'重试' WHEN 6 THEN N'失败' ELSE N'' END AS [执行状态],
       dis_his.start_time AS [开始时间],
       dis_his.duration AS [持续时间(s)],
       dis_his.comments AS [详细信息]
FROM   dbo.MSdistribution_history dis_his
WHERE
       dis_his.comments LIKE N'%传递了%' ;

---查看快照传从记录
SELECT dis_his.agent_id AS [代理ID],
       CASE dis_his.runstatus WHEN 1 THEN N'开始' WHEN 2 THEN N'成功' WHEN 3 THEN N'正在进行' WHEN 4 THEN N'空闲' WHEN N'5' THEN N'重试' WHEN 6 THEN N'失败' ELSE N'' END AS [执行状态],
       dis_his.start_time AS [开始时间],
       dis_his.duration AS [持续时间(s)],
       dis_his.comments AS [详细信息]
FROM   dbo.MSdistribution_history dis_his
WHERE
       dis_his.comments LIKE N'%已应用%快照%' ;