SQL Server Replication
SQL Server database replication feature enables copying and distribution of data between different nodes, which provide the functionality for maintaining replicated data.
Active Roles uses the replication functionality of Microsoft SQL Server to copy and distribute configuration data from one Administration Service database to another, and to synchronize data among the databases for consistency.
To understand the replication terminologies, the type of SQL Server Replication model that Active Roles uses, and the steps required to configure replication see the following topics:
- Replication terminology
- Understanding the Replication model
- SQL Server-related permissions
- Configuring SQL Server
- Configuring replication
- The replication group
- Monitoring replication
- Using Always On Availability Groups
- Using database mirroring
- Best practices
- Troubleshooting Replication failures
|
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. |