Microsoft SQL Server and Sybase Tuning Recommendations › Database Tuning Parameters › Threshold Procedures

Threshold Procedures

For Sybase, enable a threshold procedure for the last-chance threshold to back up the log when it runs out of disk space.

Note: Because Microsoft SQL Server does not provide such an option, you must back up the log frequently to keep the log small.

The following shows a sample Sybase threshold action procedure:

create procedure sp_thresholdaction 
@dbname char(40),
 @segment_name char(40),
 @space_left int,
 @status int
as
/* make the thresholdaction procedure backup the log */
declare @backdevice varchar(255)
 select @backdevice= '/u/backups/tranfile'+
       convert(char(8),getdate(),4)
 dump transaction mart to @backdevice
go