Shutting down the ASE Replicator process

You can terminate the ASE Replicator process using sp_shutdownrep. sp_shutdownrep offers two options:

In a graceful shutdown, the ASE Replicator components first complete their work on current transactions in the primary database, then empty the Distribution Database queue before terminating. After all ASE Replicator components have terminated, the ASE Replicator process terminates. A graceful shutdown can take a while to complete, depending on how many transaction operations are in the Distribution Database queue.

In an immediate shutdown, all ASE Replicator components terminate immediately, regardless of their current operations or condition, and the ASE Replicator process terminates. An immediate shutdown occurs almost instantly.

To shut down the ASE Replicator process gracefully, use sp_shutdownrep with no parameter:

sp_shutdownrep 

To shut down the ASE Replicator process immediately, use sp_shutdownrep with the immediate keyword:

sp_shutdownrep immediate