How to: Reinitialize a Subscription (SQL Server Management Studio)

How to: Reinitialize a Subscription...

Switch on low bandwidth view

Community Content

In this section

Statistics Annotations (0)

Click here to expand

Collapse All

Other versions are also available for the following:

SQL Server 2005

SQL Server 2008 Books Online (June 2009)

How to: Reinitialize a Subscription (SQL Server Management Studio)

Reinitializing a subscription is a two-part process:

A single subscription or all subscriptions to a publication are marked for reinitialization. Mark subscriptions for reinitialization in the Reinitialize Subscription(s) dialog box, which is available from the Local Publications folder and the Local Subscriptions folder in Microsoft SQL Server Management Studio. You can also mark subscriptions from the All Subscriptions tab and the publications node in Replication Monitor. For information about starting Replication Monitor, see How to: Start Replication Monitor (Replication Monitor). When you mark a subscription for reinitialization, you have the following options:
- Use the current snapshot
  Select to apply the current snapshot to the Subscriber the next time the Distribution Agent or Merge Agent runs. If there is no valid snapshot available, this option cannot be selected.
- Use a new snapshot
  Select to reinitialize the subscription with a new snapshot. The snapshot can be applied to the Subscriber only after it has been generated by the Snapshot Agent. If the Snapshot Agent is set to run on a schedule, the subscription is not reinitialized until after the next scheduled Snapshot Agent run. Select Generate the new snapshot now to start the Snapshot Agent immediately.
- Upload unsynchronized changes before reinitialization
  Merge replication only. Select to upload any pending changes from the subscription database before the data at the Subscriber is overwritten with a snapshot.
  If you add, drop, or change a parameterized filter, pending changes at the Subscriber cannot be uploaded to the Publisher during reinitialization. If you want to upload pending changes, synchronize all subscriptions before changing the filter.
A subscription is reinitialized the next time it is synchronized: the Distribution Agent (for transactional replication) or Merge Agent (for merge replication) applies the most recent snapshot to each Subscriber that has a subscription marked for reinitialization. For more information about synchronizing subscriptions, see How to: Synchronize a Push Subscription (SQL Server Management Studio) and How to: Synchronize a Pull Subscription (SQL Server Management Studio).

To mark a single push or pull subscription for reinitialization in Management Studio (at the Publisher)

Connect to the Publisher in Management Studio, and then expand the server node.
Expand the Replication folder, and then expand the Local Publications folder.
Expand the publication that has the subscription you want to reinitialize.
Right-click the subscription, and then click Reinitialize.
In the Reinitialize Subscription(s) dialog box, select options, and then click Mark for Reinitialization.

To mark a single pull subscription for reinitialization in Management Studio (at the Subscriber)

Connect to the Subscriber in Management Studio, and then expand the server node.
Expand the Replication folder, and then expand the Local Subscriptions folder.
Right-click the subscription, and then click Reinitialize.
In the confirmation dialog box that is displayed, click Yes.

To mark all subscriptions for reinitialization in Management Studio

Connect to the Publisher in Management Studio, and then expand the server node.
Expand the Replication folder, and then expand the Local Publications folder.
Right-click the publication with subscriptions you want to reinitialize, and then click Reinitialize All Subscriptions.
In the Reinitialize Subscription(s) dialog box, select options, and then click Mark for Reinitialization.

To mark a single push or pull subscription for reinitialization in Replication Monitor

In Replication Monitor, expand a Publisher group in the left pane, expand a Publisher, and then click a publication.
Click the All Subscriptions tab.
Right-click the subscription you want to reinitialize, and then click Reinitialize Subscription.
In the Reinitialize Subscription(s) dialog box, select options, and then click Mark for Reinitialization.

To mark all subscriptions for reinitialization in Replication Monitor

In Replication Monitor, expand a Publisher group in the left pane, and then expand a Publisher.
Right-click the publication with subscriptions you want to reinitialize, and then click Reinitialize All Subscriptions.
In the Reinitialize Subscription(s) dialog box, select options, and then click Mark for Reinitialization.

Tasks

Concepts

Help and Information