You can suspend and resume subscriptions for maintenance or troubleshooting. For example, you must suspend a subscription before you can delete a replicate article in that subscription.
Suspending a subscription stops queued transactions in the transaction log table from being sent to the replicate tables for that subscription.
To suspend a subscription, use sp_suspendsub:
sp_suspendsub sub_name
where sub_name is the name of the subscription.
After a subscription is suspended, you must resume the
subscription to continue replication.
You can resume all subscriptions or a specified subscription.
To resume a specified subscription, use sp_resumesub and specify the subscription:
sp_resumesub sub_name
where sub_name is the name of the subscription.
To resume all suspended subscriptions, use sp_resumesub without specifying a subscription.
