Export (0) Print
Expand All

How to create a replication agent profile (Enterprise Manager)

SQL Server 2000

How to create a replication agent profile (Enterprise Manager)

To create a replication agent profile

  1. Expand a server group, and then expand the Distributor.

  2. On the Tools menu, point to Replication, and then click Configure Publishing, Subscribers, and Distribution.

  3. Click Agent Profiles, click the tab for the type of agent to get a new profile, and then click Copy Selected Profile.

  4. Enter the name and optional description of the new profile, click the parameters you want to change, and then enter the new value.

To set the default profile for a type of replication agent

  1. Expand a server group, and then click the Distributor name.

  2. On the Tools menu, point to Replication, and then click Configure Publishing, Subscribers, and Distribution.

  3. Click the Distributor, click Agent Profiles, and then click the tab for the type of replication agent.

  4. Select the Default column next to the profile to be used as the default.

  5. Select Change all existing type Agents to use the selected profile to apply the new default to all existing type agents. Clearing this option will apply the new default only to new agents created from this point forward.

To view or modify a replication agent profile

  1. Expand a server group, expand a server, and then expand Replication Monitor.

  2. Expand Publishers, expand the Publisher name where the profile is to be modified, and then click the publication.

  3. In the details pane, right-click the agent or subscription, and then click Agent Profiles.

  4. Select an agent profile, click View Details, and then enter the value of the parameter you want to change. If you created the agent profile, you can click Modify to modify the parameters for the agent.

Note  You cannot delete the system profiles, and you cannot delete a profile if it is being used by any agent.

To delete a replication agent profile

  1. Expand a server group, and then click the Distributor name.

  2. On the Tools menu, point to Replication, and then click Configure Publishing, Subscribers, and Distribution.

  3. Click the Distributor tab, click Agent Profiles, and then click the tab for the type of replication agent.

  4. Select the profile to be deleted, and then click Delete Profile.
Show:
© 2014 Microsoft