Sample Header Ad - 728x90

TEMPDB files not correct

2 votes
1 answer
126 views
On my SQL Server 2019 Enterprise Edition server, when I run select * from sys.master_files I see that *tempdb* has 8 data files and there are 8 data files in the folder. However, when I run select * from tempdb.sys.database_files I only see 1 data file. Also, when I select the properties of *tempdb*, and look at the files, I see only 1 data file. I can delete the 7 extra files, so they are not locked or in use by SQL Server. When I restart the SQL Server service, all 8 data files appear and the whole thing repeats. There are no startup scripts or SPs that run when the service starts. What is going on?
Asked by Charles Candale (31 rep)
Dec 7, 2024, 04:13 AM
Last activity: Dec 8, 2024, 05:27 PM