• Isn’t there some global setting for model database which can configure the auto grow attribute of any new database created to allow for unrestricted access?

    Even though the model database itself has auto grow configured to unrestricted, this particular property is not inherited by the new databases created. The default restricted growth size is substantial i.e. 2,097,152 MB. I am wondering is this was done on purpose to keep the log file size in check or something by Microsoft.


    What I hear I forget, what I see I remember, what I do I understand