Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

How to: Synchronize a Pull 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 Subscriptions folder in Microsoft SQL Server Management Studio.

To synchronize a pull subscription on demand in Management Studio

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

  5. Click Close.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft