You can run the database full backup, followed immediately by a
TranLog/Truncate job.

Daniel Byers wrote:

> Since we can't backup the log file with the Truncate Log On checkpoint
> turned on, we have a major problem. The software will not trucate the log
> when it backs up the log. We could set up a Data Maintenance plan to do
> this periodically but should be an unnecessary step. Can some explain why
> the log can not be backed up with this switch on?

How do I create a TranLog/Truncate job?


Ken Putnam wrote:
>You can run the database full backup, followed immediately by a
>TranLog/Truncate job.
>
>Daniel Byers wrote:
>
>> Since we can't backup the log file with the Truncate Log On checkpoint
>> turned on, we have a major problem. The software will not trucate the
log
>> when it backs up the log. We could set up a Data Maintenance plan to
do
>> this periodically but should be an unnecessary step. Can some explain
why
>> the log can not be backed up with this switch on?
>

On the Job definition, SQL tab, job type. It's now called just Backup Transaction
Log as opposed to backup log no truncate

"Edwin Gutierrez" wrote:
>
>How do I create a TranLog/Truncate job?
>
>
>Ken Putnam wrote:
>>You can run the database full backup, followed immediately by a
>>TranLog/Truncate job.
>>
>>Daniel Byers wrote:
>>
>>> Since we can't backup the log file with the Truncate Log On checkpoint
>>> turned on, we have a major problem. The software will not trucate the
>log
>>> when it backs up the log. We could set up a Data Maintenance plan to
>do
>>> this periodically but should be an unnecessary step. Can some explain
>why
>>> the log can not be backed up with this switch on?
>>
>