Size of the Logical Log

Decide how many log files you want and what size. If you allocate more disk space than necessary, space is wasted. If you do not allocate enough disk space, however, performance might be adversely affected. Consider these points about the size and number of the logical-log files:

• The minimum size for a logical-log file is 200 kilobytes.
• The maximum size for a logical-log file is 1048576 pages (equivalent to 0x100000).
• Smaller log files mean that you can recover to a later time if the disk that contains the log files goes down. If continuous log backup is set, log files are automatically backed up as they fill. Smaller logs result in slightly longer logical recovery.
• Use larger log files when many users are writing to the logs at the same time.