Chapter 3: Administering ASE Replicator

Resuming database connections

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
```