Active Roles 7.3.1 - Replication: Best Practices and Troubleshooting

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.

Self Service Tools
Knowledge Base
Notifications & Alerts
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
Contact Us
Licensing Assistance
Technical Support
View All
Related Documents