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
Last activity: Oct 9, 2024, 03:46 AM