Unanswered: Urgent Need to know how to use sysadmin sqm_purge_queue
I have a serious problem
I have messed up a replication system in a live environment
I need to purge the queue from repserver to the secondary site
then I'll need to restore the backups
I need to know how to use the sysadmin sqm_purge_queue command
First set the replication server in hibernation mode by
sysadmin hibernate_on, <replication_serve_name>
if this doesn't work out
shutdown the replication server and modify the start_server file name by adding the -m flag like ASE. This will make the repserver to start in single user mode with dsi threads off.
After succes with any of the above steps. The run the following command.