The SQL Server Misconfiguration Chronicles part 3: Database Files
In the previous part of the SQL Server Misconfiguration Chronicles we handled the default instance memory configuration. In the third part of the misconfiguration we will handle the database files. If you create a database SQL Server will look at your model database and create the file structure as specified in your model database. By default this will mean that you will create 1 data file with a size of 4 MB and 1 log file with a size of 1 MB. These files will be able to grow automatically by auto growth, where the data file will grow in steps of 1MB and your log file will increase with 10% each growth.
