Resize Your TempDB in SQL

You can resize the tempdb temporary database in SQL by using the ALTER DATABASE command, as shown below:

ALTER DATABASE tempdbMODIFY FILE (Name = tempdb_data, filesize = 100MB),MODIFY FILE (NAME = tempdb_log , filesize = 20MB);

This resizes the data and log files of tempdb respectively.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: