Creating a replication group
To create a replication group, designate a standalone Administration Service database server as the Publisher. You can do that by using the Active Roles console:
- Connect to a standalone Administration Service.
- Promote the Administration Service database server to Publisher.
To connect to the Administration Service, use the instructions provided earlier in this chapter (see Connecting to the Administration Service).
Once connected to the Administration Service, perform the following steps to promote the Administration Server database server to Publisher:
- In the console tree, navigate to the Configuration/Server Configuration/Configuration Databases container.
- In the details pane, right-click the database and click Promote.
|
NOTE: The Promote command is only displayed if the Administration Service uses a standalone database server, that is, a database server that does not belong to any replication group. |
After you click Promote, it takes several minutes to complete the operation. When the operation is completed, the new replication group has a single member—the Publisher. Once the replication group has been created, you can add replication partners—Subscribers.
After the Promote operation is completed, both the configuration and management history databases are replicated.
If Active Roles does not have sufficient rights to perform the Promote operation on SQL Server, then the Active Roles console prompts you to supply an alternative account for that operation (see “Permissions for creating or removing the Publisher” in the Active Roles Quick Start Guide).
Adding members to a replication group
To add a member to a replication group, designate a standalone database server as a Subscriber of the group’s Publisher. You can do that by using the Active Roles console:
- Connect to the Publisher Administration Service.
- Start and complete the New Replication Partner wizard.
Once connected to the Publisher Administration Service, display the contents of the Configuration Databases container. The details pane lists the names of the Publisher and its Subscribers. Right-click the Publisher and click Add Replication Partner. Then, follow the instructions in the New Replication Partner wizard.
On the Database Selection page, click Browse to select the Administration Service that uses the database server you want to designate as a Subscriber. Clicking Browse displays the dialog box similar to that described in the Connecting to the Administration Service section earlier in this chapter. Type the name of the computer running the Administration Service, or select it from the list.
The wizard automatically selects the database server that hosts the database of the Administration Service you specify. 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 (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:
- 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 this option is selected, 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.
The account that the replication agent uses to connect to the Subscriber SQL Server must at minimum be a member of the db_owner fixed database role in the subscription database (Active Roles’ database on the Subscriber). For further details, see “Replication agent permissions” in the Active Roles Quick Start Guide.
The completion page of the wizard allows you to review summary information about the database server you are going to make a Subscriber. 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.
|
IMPORTANT: 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 server as a Subscriber, and import them back after the operation is completed. |
Steps for adding members to a replication group
To add a member to a replication group, designate a standalone database server as a Subscriber of the group’s Publisher.
To add a replication partner to a replication group
- Connect to the Administration Service whose database server holds the Publisher role.
For instructions on how to connect to the Administration Service, see Connecting to the Administration Service earlier in this chapter.
- 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.
- Use the Connect to Administration Service dialog box to select the Administration Service whose SQL Server is to be configured as a Subscriber to this Publisher.
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 (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 the SQL Server Agent service account Select 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 this option is selected, 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 Select 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.
The account that the replication agent uses to connect to the Subscriber SQL Server must at minimum be a member of the db_owner fixed database role in the subscription database (Active Roles’ database on the Subscriber). For further details, see “Replication agent permissions” in the Active Roles Quick Start Guide.
- Click Next, and the click Finish.
|
NOTE:
- 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.
- 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.
- 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.
|
Removing members from a replication group
You can remove Subscribers from a replication group by using the Active Roles console:
- Connect to the Publisher Administration Service.
- Select a Subscriber from the Configuration Databases container, right-click the Subscriber, and click Delete.
If Active Roles does not have sufficient rights to perform the operation on SQL Server, then the Active Roles console prompts you to supply an alternative account for that operation (see “Permissions for adding or removing a Subscriber” in the Active Roles Quick Start Guide).
Using this method, you can remove only Subscribers. The Publisher cannot be removed from its replication group when the group includes Subscribers.
To remove the Publisher, you must first remove all Subscribers, and then demote the Publisher. This action deletes the entire replication group.
After you remove all Subscribers, you can demote the Publisher: in the Configuration Databases container, right-click the Publisher and click Demote.
If Active Roles does not have sufficient rights to perform the Demote operation on SQL Server, then the Active Roles console prompts you to supply an alternative account for that operation (see “Permissions for creating or removing the Publisher” in the Active Roles Quick Start Guide).