cc6 replication suspended

[bukoljoe]

on my rep server monitor window > there is a SUSPENDED / WAITING FOR ENABLE MARKER..

is there a way to delete this without rebuilding / re-creating the rep server management?

 

[Vaktolteny]

Before doing this check the SCCS 5.0 Install and maintenance guide page: 1293 Everything is documented in details there!

Stage 1:
- Check if the service: REP_<computer name>_RS is running
- If no, start it
Stage 2:
Please note, this is risky, you will have low level access to the database, use with care!!
- Open a command line window.
- type: isql -Uadm -P_adm__ -S<computer name>_RS
- If DSI or DSI EXEC threads are suspended, check the log file: d:\Sybase\REP-12_5\install\<computer name>_RS.log find the server and database names that were shut down.
- In the command window type: resume connection to <Server>.<Database> [execute transaction] [skip transaction]
(for details on options execute/skip transaction please check the documentation.)
- Check reps monitor if the connection is restored or not.

 

[Jamiepockets]

If the step above from Vaktolteny doesnot work ( niceley copied directly from a certain document ) the only way around is to break the replication, i.e delete the replication information from the rep server configuration. Take a backup of the active server, restore on the standy server then re create the replication.