How to: Synchronize a Push Subscription (SQL Server Management Studio)

Subscriptions are synchronized by the Distribution Agent (for snapshot and transactional replication) or the Merge Agent (for merge replication). Agents can:

  • Run continuously

  • Run on demand

  • Run on a schedule

For more information about specifying synchronization schedules, see How to: Specify Synchronization Schedules (SQL Server Management Studio).

Synchronize a subscription on demand from the Local Publications and Local Subscriptions folders in Microsoft SQL Server Management Studio and the All Subscriptions tab in Replication Monitor. Subscriptions to Oracle publications cannot be synchronized on demand from the Subscriber. For information about starting Replication Monitor, see How to: Start Replication Monitor (Replication Monitor).

To synchronize a push subscription on demand in Management Studio (at the Publisher)

  1. Connect to the Publisher in Management Studio, and then expand the server node.

  2. Expand the Replication folder, and then expand the Local Publications folder.

  3. Expand the publication for which you want to synchronize subscriptions.

  4. Right-click the subscription you want to synchronize, and then click View Synchronization Status.

  5. In the View Synchronization Status - <Subscriber>:<SubscriptionDatabase> dialog box, click Start. When synchronization is complete, the message Synchronization completed is displayed.

  6. Click Close.

To synchronize a push subscription on demand in Management Studio (at the Subscriber)

  1. Connect to the Subscriber in Management Studio, and then expand the server node.

  2. Expand the Replication folder, and then expand the Local Subscriptions folder.

  3. Right-click the subscription you want to synchronize, and then click View Synchronization Status.

  4. A message is displayed about establishing a connection to the Distributor. Click OK.

  5. In the View Synchronization Status - <Subscriber>:<SubscriptionDatabase> dialog box, click Start. When synchronization is complete, the message Synchronization completed is displayed.

  6. Click Close.

To synchronize a push subscription on demand in Replication Monitor

  1. In Replication Monitor, expand a Publisher group in the left pane, expand a Publisher, and then click a publication.

  2. Click the All Subscriptions tab.

  3. Right-click the subscription you want to synchronize, and then click Start Synchronizing.

  4. To view synchronization progress, right-click the subscription, and then click View Details.