Change TempDB log location and size

USE [master]

 ALTER DATABASE [tempdb] MODIFY FILE ( NAME = N'tempdblog', FILENAME = N'D:\tempdb.ldf', SIZE = 204800KB , FILEGROWTH = 102400KB )

GO

Last Updated: April 13, 2024