title: How to obtain INITIAL data file size in T-SQL Query
body: <p>By initial I mean at time of database creation.</p>
  
  <p>Example:</p>
  
  <p><code>CREATE DATABASE foo ON  PRIMARY 
  ( NAME = N'foo_Data', FILENAME = N'M:\foo_data.MDF' , SIZE = 1MB , MAXSIZE = UNLIMITED, FILEGROWTH = 30%), 
   FILEGROUP [INDEXES] 
  ( NAME = N'foo_Indexes', FILENAME = N'I:\foo_Indexes.ndf' , SIZE = 1MB , MAXSIZE = UNLIMITED, FILEGROWTH = 30%)
   LOG ON 
  ( NAME = N'foo_log', FILENAME = N'L:\foo_Log.LDF' , SIZE = 1MB , MAXSIZE = UNLIMITED, FILEGROWTH = 30%)
  GO</code></p>
  
  <p>User inserts 1.1MB of records to foo database.  File size for foo_data would now be expanded to 1.3MB and 1.3MB would be reflected in sys.master_files and sys.database_files.</p>
  
  <p>Is initial size (1MB for foo_data.mdf) stored anywhere in SQL Server?</p>