To add a member to a replication group, designate a standalone database server as a Subscriber of the group’s Publisher.
|
CAUTION: Hazard of data loss! The Publisher copies new data to the database, overwriting the existing data. If the database contains valuable information, such as custom Access Templates or Policy Objects, you should export those objects before designating the database as a Subscriber, and import them back after the operation is completed. |
To add a replication partner to a replication group
-
Connect to the Administration Service whose database server holds the Publisher role.
For more information on how to connect to the Administration Service, see Connecting to the Administration Service.
-
In the Console tree, expand Configuration > Server Configuration, and click Configuration Databases.
-
In the details pane, right-click the Publisher, and click Add Replication Partner.
-
Follow the instructions in the New Replication Partner wizard.
-
On the Database Selection page, click Browse.
-
To configure the SQL Server of an Administration Service as a Subscriber to a Publisher, specify the corresponding Administration Service in the Connect to Administration Service dialog.
If Active Roles does not have sufficient rights to perform the Add Replication Partner operation on SQL Server, then the wizard prompts you to supply an alternative account for that operation. For more information, see “Permissions for adding or removing a Subscriber” in the Active Roles Quick Start Guide.
The next page of the wizard displays the database name and location retrieved from the specified Administration Service, and prompts you to select one of the following options that determine how the Replication Agent running on the Publisher SQL Server will connect to the Subscriber SQL Server.
-
Choose one of these options:
- Impersonate SQL Server Agent service account: Use this option if the SQL Server Agent service on the Publisher SQL Server is configured to log on as a Windows user account that has sufficient rights on the Subscriber SQL Server. If you select this option, the Replication Agent connects to the Subscriber SQL Server under the logon account of the SQL Server Agent service running on the Publisher SQL Server.
- Use SQL Server Authentication with the following login and password: Use this option if the SQL Server Agent service logon account cannot be configured to have sufficient rights on the Subscriber SQL Server. You are prompted to specify the SQL Server login and password that the Replication Agent running on the Publisher SQL Server will use to connect to the Subscriber SQL Server.
-
Click Next, and the click Finish.
NOTE: Consider the following when adding a replication partner to a replication group:
-
After you click Finish, the database server is added to the replication group. The replication process updates the database of the new Subscriber with the data retrieved from the Publisher.
-
A database cannot be added to a replication group if it already belongs to another replication group. To add the database to another replication group, you must first remove it from its current replication group, and then add it to the other one.