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
Last activity: Dec 8, 2024, 05:27 PM