If you do not require transactional recovery ability, you might use
simple recovery mode. If you do, constantly shrinking the log file to
have it grow back might not be the best performance minded thing to do.
If you can increase the frequency of your log backups, that might be the
best idea to keep them smaller but also retain point in time recovery
ability.

Ray Higdon MCSE, MCDBA, CCNA

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!