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 with the following syntax to specify a database connection:
sp_resumeprimaryconn "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:
sp_resumeprimaryconn
To resume a specific replicate database connection
Use sp_resumereplicateconn with the following syntax to specify a database connection:
sp_resumereplicateconn "conn_name"
where conn_name is the connection name in the form ds.db.
To resume all replicate database
connections
Use sp_resumereplicateconn without specifying a database connection:
sp_resumereplicateconn
