• ScottPletcher (9/16/2013)


    An overgrown log file can have too many VLFs, which can adversely affect performance.

    On some disks, the autogrowth can result in a less contiguous log file, which can also affect performance.

    If the log has grown very excessively, only a shrink will reduce its size.

    So, yes, sometimes there are good reason(s) to shrink a log file.

    Okay, thanks. I guess I'll do a shrink and index rebuild after I perform one of these mass mayhem events, and leave it alone otherwise.