How to Configure SQL Server Site Database Replication
Configuration Manager 2007 SQL Server site database replication can be configured to use transactional replication to allow management point and server locator point site systems to access site database information from a SQL Server replica of the site database.
注意
Configuration Manager does not support an automated method to replicate the site database.
The basic steps to configure SQL Server site database replication are:
Plan for SQL Server site database replication.
Perform pre-replication tasks to prepare SQL Server computers for site database replication.
Configure the SQL Server hosting the site database to publish the site database for replication.
Configure a subscription to the publication on a remote SQL Server that site systems configured to use a SQL Server site database replica will access.
Perform post-SQL Server replication configuration tasks.
The procedures in this section can be used to enable or disable transactional SQL Server replication for the Configuration Manager 2007 site database.
In This Section
- Planning for SQL Server Site Database Replication
Describes planning considerations for implementing SQL Server site database replication.
- How to Perform Required Pre-Replication Setup Tasks
Describes the pre-replication configuration tasks required to enable SQL Server site database replication.
- How to Configure the SQL Server Publisher Computer
The publication step allows you to select the data and database objects you want to replicate and filter the published data so that subscribers receive only the data that is needed.
- How to Configure the SQL Server Subscriber Computer
The subscription step allows you to subscribe to the site database information needed to support site systems configured to access SQL Server replica of the site database.
- How to Perform Required Post-Replication Setup Tasks
Describes the post-replication configuration tasks required to enable site systems to access SQL Server site database replica information.
- How to Configure Site Systems to Access a SQL Server Site Database Replica
Describes the procedures used to configure the management point and server locator point site systems to access a SQL Server site database replica from within the Configuration Manager console.
- How to Disable SQL Server Database Replication
Describes the procedure to disable SQL Server site database replication.