Suspends all ASE Replicator processing (log reading and distribution), database connections, and subscriptions, but does not shut down the ASE Replicator process or its components.
sp_suspendrep
sp_suspendrep
Suspends all ASE Replicator replication processing.
Suspending the replication system rolls back any current operations and stops all replication system processing immediately.
When you invoke sp_suspendrep, ASE Replicator components perform the following actions:
The Publisher component stops scanning the primary database’s native ASE transaction log, discards all transactions in its internal queue, and rolls back any incomplete transactions it is processing in the stable queue.
The Distributor component rolls back any of its transactions being processed in the replicate database and stops scanning the stable queue.
To resume replication operations after suspending, use sp_resumerep.
When the requested action occurs successfully, no results are returned.
When an error occurs, an error message is returned.
sp_resumerep
