How to set HistoryVerboseLevel Profile for all Agent

Share this Post

This is a follow up post to my article Using “Verbose history agent profile.” while troubleshooting Replication.

Using SQL Server Management Studio you can set a default profile for all Replication Agents.  In this walk through I’ll change ALL Merge Agents default to use the “Verbose History Agent Profile”.

In SSMS, right click the Replication folder and select Distributor Properties. Near the bottom of the dialog select “Profile Defaults”.

image

Select Merge Agent page, then select “Verbose history agent profile”.

image

This profile, similar to the default, has HistoryVerboseLevel = 3 to record detailed Merge history data in the MSmerge_history table in the Distribution database.  To apply this new profile setting to ALL Merge Agent select “Change Existing Agents” then click OK.

image

While troubleshooting Replication you may want to increase the “History Retention”. Increasing DETAIL and keeping longer history will grow your distribution database.

image

image

Chris Skorlinski
Microsoft SQL Server Escalation Services


Share this Post

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.