Post reply

Where does SQL Server store information about Tempdb configurations

  • May 29, 2015 at 3:25 am

    #308693

    Hi Experts,

    Whenever SQL Server get restarted, tempdb gets recreated with its last configuration.

    Could anybody let me know where SQL Server store tempdb configurations? How does it know

    how many Tempdb files it needs to create on restart?

    Thanks,

    Dev

  • May 29, 2015 at 3:56 am

    #1801509

    the metadata is stored in the master database. The main catalog is sys.master_files which contains file information for all databases. There is also a catalog inside each database called sys.database_files which holds file info for that particular database

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

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • May 29, 2015 at 4:16 am

    #1801518

    Thank you Perry

Viewing 3 posts - 1 through 2 (of 2 total)

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