Jim

Truncating the log only removes none, some or all of the entries from it; it doesn't shrink it. You should consider backing up your log instead of truncating it, so that you don't lose your log chain and hence your ability to restore to a point in time in the event of a disaster. You might also consider doing your updates in small batches. This, combined with regular log backups, should limit the growth of your log file.

For more details and a better explanation, start with this[/url].

John