• If you have explicitly amended the size of a tempdb database file via an alter database command that is the size it will recreated at on restart.

    Any data in tempdb will be lost on restart.

    In the GUI the initial size shown for the file is the size on creation, not the size it has grown to if there have been any autogrowths since restart.

    ---------------------------------------------------------------------