Managing the system databases

Managing the SQL Server system databases: move the tempdb files to another drive and reduce the number of tempdb files.

Move tempdb files

Generate and run the ALTER DATABASE script that moves the tempdb files to another drive, effective when the SQL Server service restarts.

Remove tempdb files

Why DBCC SHRINKFILE EMPTYFILE often fails on tempdb, and two ways to remove extra files: minimal configuration mode or a startup Agent job.