• vk-kirov (1/21/2010)


    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.

    Oooh, what a logical place .... NOT! 😉

    Thanks for finding it, and for posting it here.


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/