Failing over, failing back, creating proxy databases, and so on, are log-intensive activities. If you do not have adequate log space, any of these activities can fail. If you have not already done so, you must add a threshold to the master log.
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 Chapter 16, “Managing Free Space with Thresholds,” in the System Administration Guide: Volume 2 and the Reference Manual: Procedures for information about creating this system procedure.
Place thresholds on the master log segment so it does not fill up:
sp_addthreshold "master", "logsegment", 250, sp_thresholdaction
Restart the primary companion for this static parameter to take effect.
