Share via


Reinitialize Subscription(s) - One Subscription

The Reinitialize Subscription(s) dialog box allows you to mark a subscription for reinitialization. Reinitialization involves applying a snapshot to the Subscriber; it is performed by the Distribution Agent for subscriptions to transactional publications and by the Merge Agent for subscriptions to merge publications.

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 will not be 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.

  • Mark for Reinitialization
    Click to mark the subscription for reinitialization. After a valid snapshot is available, the next time the Distribution Agent or Merge Agent runs for the subscription, the snapshot is applied at the Subscriber.

See Also

Other Resources

Reinitializing a Subscription

Help and Information

Getting SQL Server 2005 Assistance