• Sounds good to me. Thanks for posting back the results.

    Now might be a good time to double-check on your auto-grow settings too. I like to use MB instead of % because growth is more predictable that way. I also like to autogrow the log file in relatively chunks, anywhere between 128MB and 512MB depending on the size and power of the server. Log files cannot be instantly initialized like data files so large log growth operations can cause huge delays for the lucky query that happens to initiate them.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato