You can resume either a specific (primary or replicate) database connection, or all primary or all replicate database connections.
When you resume a replicate database connection, you
also resume all subscriptions in that connection.
To resume a specific primary database connection, use sp_resumeprimaryconn and specify a database connection:
sp_resumeprimaryconn "conn_name"
where conn_name is the connection name in the form ds.db.
To resume a specific replicate database connection, use sp_resumereplicateconn and specify a database connection:
sp_resumereplicateconn "conn_name"
where conn_name is the connection name in the form ds.db.
To resume all primary database connections, use sp_resumeprimaryconn without specifying a database connection.
To resume all replicate database connections, use sp_resumereplicateconn without specifying a database connection.
