SQLKnowItAll (1/30/2013)
I always specify my size in the script, so...
Yep, me too.
crazy4sql (1/30/2013)
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.
Thanks for trying Gaz. Did you tried after modifying the model data and log file size? My environment is sql 2008 sp3cu2 where I can replicate the issue.
Yep, changed data file to 200MB and log to 20MB on model (from defaults 3MB/1MB).
Then ran "create database model_test" - files were created as 200MB & 20MB.
That's on 2008R2 SP2. I don't have any 2008 builds available at the moment, so can't test on your specific version.
Cheers
Gaz