Suspending replication allows you to stop replication system operation for maintenance or troubleshooting, without terminating the ASE Replicator process.
When you suspend replication, the ASE Replicator Publisher and Distributor components complete their work on current transactions in the primary database, then empty the Distribution Database stable queue before terminating.
Suspending replication also suspends all database connections
and all subscriptions.
To suspend replication
Use sp_suspendrep:
sp_suspendrep
Suspending replication may take a while to complete, usually a few seconds.
After you suspend replication, the ASE Replicator process component is essentially in an “admin” state, in which no replication takes place, but you can execute ASE Replicator procedures to perform administrative tasks.
If a maintenance procedure affects only one database object, or one database, you can suspend just the individual subscription or database connection involved. See “Suspending and resuming subscriptions” or “Suspending and resuming database connections” for more information.
