To shrink the TempDB MDF file (before adding additional NDF files for example), whilst retaining the total size of 50GB …
DBCC FREEPROCCACHE USE [tempdb] GO DBCC SHRINKFILE (N'tempdev' , 8192) GO
To shrink the TempDB MDF file (before adding additional NDF files for example), whilst retaining the total size of 50GB …
DBCC FREEPROCCACHE USE [tempdb] GO DBCC SHRINKFILE (N'tempdev' , 8192) GO