Where does SQL Server store information about Tempdb configurations
-
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
-
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"
-
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