Hi,

You can set up and schedule a job to truncate log file periodically. Here is the script that I use for truncating log files:

EXEC sp_addumpdevice 'disk', 'CFSales_Dat', 'F:\SQL2000\MSSQL\BACKUP\CFSales_dat.dat'

GO

EXEC sp_addumpdevice 'disk',...