ALTER DATABASE [tempdb] 

MODIFY FILE (NAME='tempdb', FILENAME='T:\Databases\TempDB\tempdb.ndf', Size=30GB);

Last Updated: April 13, 2024