How to modify Publisher and Distributor properties (Enterprise Manager)

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.