Export (0) Print
Expand All

How to Configure SQL Server Site Database Replication

Updated: April 1, 2009

Applies To: System Center Configuration Manager 2007, System Center Configuration Manager 2007 R2, System Center Configuration Manager 2007 R3, System Center Configuration Manager 2007 SP1, System Center Configuration Manager 2007 SP2

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.

noteNote
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:

  1. Plan for SQL Server site database replication.

  2. Perform pre-replication tasks to prepare SQL Server computers for site database replication.

  3. Configure the SQL Server hosting the site database to publish the site database for replication.

  4. 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.

  5. 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.

See Also

For additional information, see Configuration Manager 2007 Information and Support.
To contact the documentation team, email SMSdocs@microsoft.com.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft