How to truncate the MS SQL log in schedule backup

I reviewed the documents, it should truncate the log autometically.

Right?

Have you checked some past threads? This question has arised few times if I remember correctly.

What backup command are you using? Logfile trunking is skipped when -T or -G options are set.

Hi,

I remember that backup doesn't affect the physical size of the log. If you want to shrink the physical size, you must use some sql database tools to do that.

I do not use -T and -G options and the command is nsrsqlsv -a my_virtual_server.
The log size does not decrease after the backup job completed.

So I post this topic to discuss the backup job will truncate the log or not.

Dennis

Have you checked:
http://forums.emc.com/forums/thread.jspa?tstart=0&threadID=36105

Thanks for following info:

Deafult behavior in NMSQL 5.0 is that log truncation is only enabled with FULL backup. Additionally, NMSQL 5.0 only trucncates logs if the user explicitly specifies log truncation. So by default NMSQL 5.0 does not trucate logs. Therefore NMSQL 5.0 should never disrupt the log shipping environment unless user himself chooses to do log trucation.

So Full backup will not truncate logs by default?
How to specify log truncation? I can not find any thing in administration guide.

Best Regards,
Dennis