Add Thresholds to the Master Log

If you have not already done so, you must add a threshold to the master log.

  1. Define and execute sp_thresholdaction on the master database’s log to set a threshold on the number of pages left before a dump transaction occurs. Sybase does not supply sp_thresholdaction. See the Adaptive Server Reference Manual for information about creating this system procedure.

  2. Place thresholds on the master and sybsystemprocs log segments so they do not fill up:

    sp_addthreshold "master", "logsegment", 250, sp_thresholdaction
    sp_addthreshold "sybsystemprocs", "logsegment", 250, sp_thresholdaction
    
  3. You need to do this on both the primary and secondary servers. After you have completed these tasks, reboot both servers to allow some of the static configuration parameters to take effect.