How to Configure SQL Server Site Database Replication

Updated: April 1, 2009

Applies To: System Center Configuration Manager 2007

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.

Note
Configuration Manager 2007 does not support an automated or scripted method to configure replication of 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.

In This Section

See Also

Concepts