• Hugo Kornelis (1/21/2010)


    The documentation on CREATE DATABASE is here: http://technet.microsoft.com/en-us/library/ms176061.aspx.

    The default log file size is only given in one of the examples (unless I overlooked something)

    It is given in the description of the LOG ON argument:

    LOG ON

    If LOG ON is not specified, one log file is automatically created that has a size that is 25 percent of the sum of the sizes of all the data files for the database or 512 KB, whichever is larger.