Replication Properties

SQL Replication

Replication

Replication Properties

After you configure replication, you can view and modify options by using the properties dialog boxes for replication. Properties are available for the Publisher, its Subscribers, and the Distributor, publications, push subscriptions, pull subscriptions, and replication agents.

Publisher and Distributor Properties

After you have configured a Publisher and Distributor using the Configure Publishing and Distribution Wizard, you can view and modify those options using the Publisher and Distributor properties. The Publisher and Distributor properties include the following tabs and information.

Tab Information
Distributor The distributor name, distribution databases, properties for the distribution database, buttons to create or delete a distribution database, a button to see the agent profiles for all replication agents, and the administrative link password for Publishers to connect to the Distributor.
Publishers A list of Publishers that have been enabled to use this Distributor during replication, and buttons to enable, disable, or specify new Publishers.
Publication Databases A list of databases that are enabled for transactional replication (includes snapshot replication) and/or merge replication, and buttons to enable or disable the databases for transactional replication and/or merge replication.
Subscribers A list of Subscribers configured to receive data from this Distributor, and buttons to enable, disable, or specify new Subscribers.

To open Publisher and Distributor properties