Replication Queue Reader Agent Utility
The Replication Queue Reader Agent utility configures and begins the Queue Reader Agent, which reads messages stored in a SQL Server queue or a Microsoft Message Queue and then applies those messages to the Publisher. Queue Reader Agent is used with snapshot and transactional publications that allow queued updating.
Note Parameters can be specified in any order. When optional parameters are not specified, values from predefined registry settings on the local computer are used.
Displays usage information.
Specifies whether the agent attempts to process queued transactions continuously. If specified, the agent continues execution even if there are no queued transactions pending from any of the subscribers.
Is the path of the agent definition file. An agent definition file contains command prompt arguments for the agent. The content of the file is parsed as an executable file. Use double quotation marks (") to specify argument values containing arbitrary characters.
Is the Distributor name. Specify server_name for the default instance of SQL Server 2000 on that server. Specify server_name\instance_name for a named instance of SQL Server 2000 on that server. If not specified, the name defaults to the name of the default instance of SQL Server on the local computer.
Is the distribution database.
Is the Distributor login name.
Is the Distributor password.
Specifies the security mode of the Distributor. A value of 0 indicates SQL Server Authentication Mode (default), and a value of 1 indicates Windows Authentication Mode.
Specifies the amount of history logged during a queue reader operation. You can minimize the effect of history logging on performance by selecting 1.
|HistoryVerboseLevel value|| |
|1||Default. Always update a previous history message of the same status (startup, progress, success, and so on). If no previous record with the same status exists, insert a new record.|
|2||Insert new history records unless the record is for such things as idle messages or long-running job messages, in which case update the previous records.|
Is the number of seconds before the login times out. The default is 15 seconds.
Is the path of the agent output file. If the file name is not provided, the output is sent to the console. If the specified file name exists, the output is appended to the file.
Specifies whether the output should be verbose. If the verbose level is 0, only error messages are printed. If the verbose level is 1, all the progress report messages are printed. If the verbose level is 2 (default), all error messages and progress report messages are printed, which is useful for debugging.
Is relevant only for updating subscriptions that use SQL Server based queues. Specifies how often, in seconds, the SQL Server queue is polled for pending queued transactions. The value can be between 0 and 240 seconds. The default is 10 seconds.
Is the number of seconds before the query times out. The default is 300 seconds.
Specifies how queued updating conflicts are resolved. A value of 1 indicates the Publisher wins the conflict, and the current conflicting queued transaction will be rolled back on the Publisher and the originating updating Subscriber; the processing of subsequent queued transactions will continue. A value of 2 indicates the Subscriber wins the conflict, and the queued transaction will override the values on the Publisher. A value of 3 indicates that any conflict will result in Subscriber re-initialization; the Publisher wins the conflict, processing of subsequent queued transactions will be terminated, and the subscription will be reinitialized. The default setting is 1 for transactional publications and 3 for snapshot publications.