SQLKnowItAll (1/30/2013)
After reviewing BOL, I do not see anywhere that it states that the file sizes are copied from model. In fact, the only reference I see to file size is this:The sizes of these files can vary slightly for different editions of SQL Server.
CREATE DATABASE has this:
SIZE size
When size is not supplied for the primary file, the Database Engine uses the size of the primary file in the model database. When a secondary data file or log file is specified but size is not specified for the file, the Database Engine makes the file 1 MB. The size specified for the primary file must be at least as large as the primary file of the model database.
I just tried on a dev machine and I can't reproduce crazy4sql's behaviour though - my new DB has the same file sizes as my model DB.
Cheers
Gaz