what is the difference between -HistoryVerboseLevel and -OutpytVerboseLevel in Merge replication agent

asked 2022-12-22T01:55:40.44+00:00
Gao Peng 21 Reputation points

Still in a Merge Agent profile, 2 arguments/parameters seem to have overlapping functionality. What is the actual difference between history during a merge operation and the output.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,484 questions
No comments
{count} votes

1 answer

Sort by: Most helpful
  1. answered 2022-12-22T07:19:11.887+00:00
    NikoXu-msft 1,901 Reputation points

    Hi @Gao Peng ,

    -HistoryVerboseLevel [1|2|3]
    Specifies the amount of history logged during a merge operation. You can minimize the effect of history logging on performance by selecting 1.

    HistoryVerboseLevel value Description
    0 Log the final agent status message, final session details, and any errors.
    1 Log incremental session details at each session status, including percent complete, in addition to the final agent status message, final session details, and any errors.
    2 Default. Log both incremental session details at each session status and article level session details, including percent complete, in addition to the final agent status message, final session details, and any errors. Agent status messages are also logged.
    3 The same as -HistoryVerboseLevel = 2, except that more agent progress messages are logged.

    -OutputVerboseLevel
    Gets or sets the amount of information that is logged by the Distribution Agent in the agent output file.

    Value Description
    0 Only error messages are printed.
    1 All the progress report messages are printed.
    2 (default) All error messages and progress report messages are printed. This is useful for debugging.

    Best regards,
    Niko
    --------
    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.