steve mason

Hey all,
If I set up a database in 2GB file size, what is the
corresponding log file size in general? Is there any size
concern between them?
thanks
Steve

andrew j. kelly

The proper size of the log file will be dictated by the types of
transactions you have, the number of them and how often you back up the log
file. There is no correct vs incorrect size unless it is too small. If it
is it will auto grow until it gets to the size it needs to operate normally.
There is no penalty for having too large of a log but there can be for too
small as it will need to grow. Growing can be resource intensive. Just
make it kind of small at creation time and manually grow it to a reasonable
size shortly afterwards since you can only shrink the file as small as it
was originally created at.

--

Andrew J. Kelly
SQL Server MVP