I would almost say, in that situation, if you've got the disk space, it might be easiest to do the following:

1. Backup the TLog

2. Shrink it down as small as possible (don't worry!)

3. Set it to a size large enough to handle your data loads and a bit more (so using your 560MB one, maybe make it ~650MB)

4. Either turn off autogrowth, or set it to a more "reasonable" number to avoid a lot of VLFs

IIRC, and someone correct me if I'm wrong, by shrinking the log, then growing it in one "chunk" you'll get a better number of VLFs.

OK, here's the article I was thinking of in terms of the VLFs[/url] from SQLSkills.

Plan your log size to have a "reasonable" number of VLFs, size it, and leave it (if you've got the disk space, and now-a-days, disk is cheap...)

Jason