Consider the following when removing members from a replication group:
-
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 replication group. After you remove all Subscribers, you can demote the Publisher.
-
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. For more information, see “Replication configuration permissions” in the Active Roles Quick Start Guide.
To remove Subscribers from a replication group
-
Connect to the Publisher Administration Service.
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 Subscriber, and then click Delete.
To remove the Publisher from a replication group
-
Connect to the Publisher Administration Service.
-
In the Console tree, expand Configuration > Server Configuration, and click Configuration Databases.
-
In the details pane, right-click the Publisher, and then click Demote.
NOTE: The Demote command is not displayed unless the Publisher is the only member of the replication group.
Active Roles makes it possible to monitor the status of replication partners. Monitoring allows you to determine whether Active Roles replication is working efficiently and correctly.
To view the status of a replication partner via the Active Roles Console
-
Connect to any Administration Service within the replication group.
-
Open the Properties dialog for the replication partner and navigate to the Replication Status tab.
For more information on how to connect to the Administration Service, see Connecting to the Administration Service.
Once connected to the Administration Service, perform the following steps to open the Properties dialog for a replication partner.
To open the Properties dialog for a replication partner
-
In the Console tree, expand Configuration > Server Configuration, and click Configuration Databases.
-
In the Details pane, right-click the replication partner, and click Properties.
The Replication Status tab in the Properties dialog provides information about the last replication action of the partner and indicates whether the action completed successfully, failed, or is in progress.
If there are any replication failures in Active Roles, the Active Roles Console displays next to Server Configuration and Configuration Databases containers in the Console tree. This allows you to detect a replication failure without examining individual databases.
For more information on how to monitor the health of Active Roles replication, refer to Active Roles Replication: Best Practices and Troubleshooting.