You can suspend either a specific (primary or replicate) database connection, or all primary or all replicate database connections.
When you suspend a replicate database connection, you
also suspend all subscriptions in that connection.
To suspend a specific primary database connection, use sp_suspendprimaryconn and specify a database connection:
sp_suspendprimaryconn "conn_name"
where conn_name is the connection name in the form ds.db.
To suspend a specific replicate database connection, use sp_suspendreplicateconn and specify a database connection:
sp_suspendreplicateconn "conn_name"
where conn_name is the connection name in the form ds.db.
To suspend all primary database connections, use sp_suspendprimaryconn without specifying a database connection.
To suspend all replicate database connections, use sp_suspendreplicateconn without specifying a database connection.
After a database connection is suspended, you must resume
the connection to continue replication.
