Introduction
Introduction
This document is designed for those who administer Active Roles and want to learn more about the Active Roles replication function. The document is intended to help Active Roles administrators configure and monitor Active Roles replication using Microsoft SQL Server tools.
This document details the SQL Server agents used during replication, accounts and logins used to access SQL Server, and strategies for monitoring and troubleshooting replication. The following topics are covered:
- Understanding the Active Roles replication model
- SQL Server-related permissions of Administration Services
- Replication maintenance-related tasks and troubleshooting
|
|
NOTE: SQL Server Books Online should be the primary resource you use for SQL Server replication questions. All contents relevant to Microsoft SQL Server replication is indexed under the “SQL Server Replication” topic in SQL Server Books Online at http://technet.microsoft.com/library/ms151198.aspx. |
Understanding the replication model
Understanding the replication model
This section briefly discusses SQL Server replication functions used by Active Roles.
Terminology
Terminology
Replication
To replicate its configuration data, Active Roles employs the replication capabilities of Microsoft SQL Server. In SQL Server, the term replication refers to a process that copies and distributes data and database objects from one database to another and then synchronizes information between databases for consistency.
Publisher
Publisher
The Publisher is a database server that makes data available for replication to other database servers. The Publisher can have one or more publications, each representing a logically related set of data. In the Active Roles replication model, the Publisher has only one publication.