Sample Header Ad - 728x90

SQL Server 2019 tempdb files won't shrink

-1 votes
1 answer
117 views
I have a tempdb configured with 8 datafiles and 1 log file. Originally the datafiles were all set to the same size, however, they have grown over time and are now all different sizes. I was able to shrink a few back to the original file size, but there are 4 that won't shrink. All the files show 99% free space in them. I've verified that there are no open transactions in the database and that there is nothing currently using tempdb. How can I shrink those last few -- I wouldn't worry about it at all except the database is approaching the 2 TB limit. Thanks!
Asked by Eyespi20 (1 rep)
Oct 4, 2024, 12:58 PM
Last activity: Oct 9, 2024, 03:46 AM