Dropping a Replication Server Subscription

Remove a Replication Server subscription from a Replication Server.

Prerequisites

Make sure the Replication Server is running. Create and establish a connection to the server.

In Enterprise Explorer, expand the view for your Replication Server connection profile, and expand the view for the replicate database containing the replication subscription you want to drop.
Expand the Subscriptions folder, right-click the subscription, and select Drop.

Specify drop options, and click OK.

Option	Description
Without Purge	Choose an option for dropping without purge: Without Suspension – drops the subscription without the with suspension option. With Suspension – leaves the connection to the replicate database suspended when drop subscription has completed, so you can manually remove the rows. With Suspension at Active Replicate Only – for warm standby applications, suspends the active replicate database but not the standby replicate database.
With Purge	Choose an option for dropping with purge : Incrementally – specify that dematerialization occurs in row increments of deletes-per-transaction. Nonincrementally – specify for nonincremental dematerialization.

Option

Description

Without Purge

Choose an option for dropping without purge:

Without Suspension – drops the subscription without the with suspension option.
With Suspension – leaves the connection to the replicate database suspended when drop subscription has completed, so you can manually remove the rows.
With Suspension at Active Replicate Only – for warm standby applications, suspends the active replicate database but not the standby replicate database.

With Purge

Choose an option for dropping with purge :

Incrementally – specify that dematerialization occurs in row increments of deletes-per-transaction.
Nonincrementally – specify for nonincremental dematerialization.

Next

For details about the with purge clause, see the Replication Server Administration Guide.