Topic Last Updated—August 2008

The publication step allows you to select the data and database objects you want to replicate so that subscribers receive only the data that is needed. Configuration Manager 2007 does not support full site database replication and only specific site database objects should be replicated.

Note
In Configuration Manager 2007 installations, there are 98 objects that must be replicated to support site systems accessing site database replicas (48 tables, 44 stored procedures, 4 views, and 2 user defined functions). In Configuration Manager 2007 SP1 installations, there are 99 objects that must be replicated to support site systems accessing site database replicas (49 tables, 44 stored procedures, 4 views, and 2 user defined functions).

Before starting these procedures, ensure that the pre-replication required tasks have been completed. For more information about pre-replication setup required tasks, see How to Perform Required Pre-Replication Setup Tasks.

The following procedures can be used to configure the SQL Server hosting the site database to publish the site database for replication and act as its own distributor.

To configure the SQL Server hosting the site database to publish the site database for replication

  1. In the SQL Server 2005 SQL Server Management Studio console connected to the SQL Server hosting the site database, right click Replication and click Configure Distribution to start the Configure Distribution Wizard.

  2. Click Next on Welcome Page (if displayed).

  3. On the Distributor page, select '<Site Server Name>' will act as its own Distributor; SQL Server will create a distribution database and log.

  4. If the SQL Server Agent service is not already started, it must be started on the SQL Server Agent Start page.

    Note
    If the SQL Server service account does not have administrative rights on the SQL Server computer, the SQL Server Agent service must be started manually and configured to start automatically when the SQL Server starts.

  5. On the Snapshot Folder page, enter an empty shared network resource that will be accessed by subscriber SQL Servers to retrieve site database snapshot information stored there.

    Important
    A valid UNC share path must be specified for the snapshot folder. Using a local drive path for the snapshot folder will not support pull subscriptions created on the subscriber SQL Server computer.

  6. On the Distribution Database Name page, specify the database name and database file installation directories of the system database to be created to support site database distribution.

    Note
    The distribution database file installation paths must be local to the SQL Server computer and start with a drive letter and colon (for example, C:).

  7. On the Publishers Page, select the SQL Server hosting the site database to use the distributor database when it becomes a publisher.

  8. On the Wizard Actions page, select Configure distribution.

  9. On the Complete the Wizard page, verify the settings that will be used to configure distribution and click Finish.

  10. After distribution configuration has completed, click Close on the Configuring page.

To configure a new local publication for required SQL Server replica site database information

  1. In the SQL Server 2005 SQL Server Management Studio console connected to the SQL Server hosting the site database, expand Replication, right click Local Publications and click New Publication to start the New Publication Wizard.

  2. Click Next on the New publication Wizard welcome page.

  3. Select the site database on the Publication Database page.

  4. On the Publication Type page, select Transactional publication.

  5. On the Articles page, select the required site database objects to publish as replication articles. To determine the required site database objects to be published:

    • In the SQL Server Management Studio console, right click the site database name and select New Query.

    • In the SQL Server Management Studio results pane, enter the following query: Select ObjectName from ReplicatedObjects where SiteSystemType = 'MP' and click Execute.

      Note
      The objects required to support server locator point site systems to access SQL Server site database replicas are returned as part of the management point replicated objects query. No further objects need to be configured for replication after this step is completed to support server locator point site systems configured to access the site replica. If you are only configuring SQL Server site database replication to support server locator point access to the SQL Server replica, you can use the following query: Select ObjectName from ReplicatedObjects where SiteSystemType = 'SLP'.

  6. On the Article Issues page, ensure that the listed tables and objects have been selected for replication.

  7. On the Filter Table Rows, do not add any table filters.

  8. On the Snapshot Agent page, select Create a snapshot immediately and keep the snapshot available to initialize subscriptions. Select the Schedule the Snapshot Agent to run at the following times: and accept the default schedule. Alternatively, you can click Change to configure the daily schedule frequency for the snapshot agent to occur according to your replication requirements.

  9. On the Agent Security page, click Security Settings… and configure the accounts used for the Snapshot Agent and Log Reader Agent.

  10. On the Wizard Actions page, verify that Create the publication is selected.

  11. On the Complete the Wizard page, enter a name for the Publication and review the publication settings and click Finish.

  12. On the Creating Publication page, click close after the publication is created.

See Also