Configuring Replication Distribution Options
Using SQL Enterprise Manager, you can configure the distribution database agent logon information, amount of time to hold replicated transactions, and holding time of replication performance information. Additionally you can view all the publishers using the distribution database. To set distribution database options, perform the following:
1. |
Select the server on which you want to configure the distribution database options.
|
2. | From the SQL Enterprise Manager menu, select Tools and then select Replication. A drop-down menu appears; select the Configure Publishing, Subscribers, and Distribution option. The Publisher and Distributor Properties dialog box appears, with the Distributor tab, shown in ... |
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
