• Jeff Moden (10/26/2016)


    p.s. As for ascertaining the recommended size for the log files, you could write a script to (for each DB)...

    1. Set the SIMPLE recovery model.

    2. Change the initial size and growth of each log file to 100MB each.

    3. Shrink the log file to 0 (don't worry about pregrowing it here, it'll grow)

    4. Set the FULL recovery model.

    5. Wait for a week.

    After a week passes, the log files will have grown because of the FULL recovery model. ...<snip>

    This could blow the size (and fill up the filesystem) quickly on a busy system!! Unless you perform regular LOG backups (which is not mentioned in the above steps ;-)). Regular LOG backups determine the final size of the LOG backup, depending on the frequency of the backups.

    I would skip step 4 and leave the database in SIMPLE recovery. After a week I would determine the size as to the size after a week plus an additional 20% or 30%.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **