• If the log file still grows after the Truncate log on check point ON, you might want to schedule a hourly job with the following commands

    use <Database_Name>

    go

    dbcc shrinkfile (Log_Filename, 300)

    go

    backup log Database_Name with no_log

    go

    As Randy suggested make sure you have full backup

    Shas3