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'%已應用%快照%' ;