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.
Generate and run the ALTER DATABASE script that moves the tempdb files to another drive, effective when the SQL Server service restarts.
Why DBCC SHRINKFILE EMPTYFILE often fails on tempdb, and two ways to remove extra files: minimal configuration mode or a startup Agent job.