• I've had a few issues with rogue transaction logs as well (on MSDE at any rate). Even on autoshrink I've had them grow to over 10GB, and didn't even notice it.

    They are pretty easy to deal with though - truncate them (WITH TRUNCATE ONLY) then shrink.

    A lot of installations we have scheduled maintenance jobs that do this, and defrag indexes periodically.