Tempdb datafile initial file sizes changed by SQL Server itself?

  • These are not initial but current sizes. SQL Server does not keep the file size at the time when you have initially created database. Check sys.database_files view. It has size, max_size, growth fields, but not initial size. If you are referring to SSMS database properties/files, that wording is actually misleading. It should read just "Size (MB)".

Viewing post 1 (of 2 total)

You must be logged in to reply to this topic. Login to reply