Vani, 

The option is already set, but thanks for the idea.

Like stancenic mentioned in his/her post, the truncate on checkpoint doesn't always seem to happen like one would expect.

Thanks again...

Thank you stacenic and jadowse. The transaction log is now at an acceptable size.

Thanks. I'll give it a try tonight.

Yes, I've thought about trying that. 

Will it really help? I thought that since checkpoints have been issued it would have performed a log truncation already, especially when the server was shutdown.

But maybe...

We use ProClarity.

Some users that are not doing in-depth analysis are just as happy to use MS Excel.