Export (0) Print
Expand All
Expand Minimize

How to modify Publisher and Distributor properties (Enterprise Manager)

SQL Server 2000

How to modify Publisher and Distributor properties (Enterprise Manager)

To add, modify, or remove a Publisher

  1. In SQL Server Enterprise Manager, expand a server group, expand the Distributor, right-click the Replication folder, and then click Configure Publishing, Subscribers, and Distribution.

  2. Select what you want to do with the Publisher.
    • To add a Publisher, click the Publishers tab, and then select a Publisher to enable.

    • To modify a Publisher, click the Publishers tab, click the Publisher to modify, and then click the properties button (...).

    • To remove a Publisher, click the Publishers tab, and then clear the box next to the Publisher name.

    Note  If the Publisher does not have items in the distribution database, a confirmation prompt will not appear.

To modify a Distributor or add or modify a distribution database

  1. In SQL Server Enterprise Manager, expand a server group, expand the Distributor, right-click the Replication folder, and then click Configure Publishing, Subscribers, and Distribution.

  2. Select what you want to do with the Distributor.
    • To modify Distributor properties, click the Distribution tab to change the password for connecting to the Distributor or set agent profiles.

    • To add a distribution database, click the Distributor tab, click New, and then enter a database name and the location for the database and log files.

    • To modify the distribution database, click the Properties button for the distribution database to change the transaction retention period or the history retention period.
Show:
© 2014 Microsoft