link to 2008 BOL: ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_6tsql/html/29ddac46-7a0f-4151-bd94-75c1908c89f8.htm
excerpt of text:
Is the initial size of the file.
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.
1) How does this correlate with your earlier statement (The answer is the same size as the model database
)? As we can see, the size of the newly created log file will not be equal to the model db log file size (unless modellog.ldf = 1 MB).
2) How about the case when log file specifications are missing at all? (e.g. 'CREATE DATABASE TestDB' – even this simple statement can be run)
BOL say what will happen (please check the link you provided):
If LOG ON is not specified, one log file is automatically created that has a size that is 25 percent of the sum of the sizes of all the data files for the database or 512 KB, whichever is larger.
Once again, the size of the newly created log file will not be equal to the model db log file size.
3) The author of the question says in the explanation he created the database via SSMS UI. In this case SSMS specifies all file properties. For example, my SSMS 2008 produces this script:
CREATE DATABASE [TestDB] ON PRIMARY
( NAME = N'TestDB', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\TestDB.mdf' ,
SIZE = 3072KB , FILEGROWTH = 1024KB )
( NAME = N'TestDB_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\TestDB_log.ldf' ,
SIZE = 1024KB , FILEGROWTH = 10%)
What is the relation between this code and the model database size?
as we all know - if this were the old Soviet union days - SQL Server would have been invented in USSR and stolen by american capitalist pigs
Excuse me, who are these mysterious "we all"? :-D Please don't tell that "we all" = "my very self"
my comments about russian version of SQL Server were SARCASMWe all
see your great sense of humor. Stand-up comedy scene is waiting for you ;-)