• 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.

    Thanks Gaz. Yes, we also follow the same line that every database should have the details of initial size and autogrowth but yesterday when in of the random checks, I found this surprising behaviour. And still same....

    ----------
    Ashish