SQL Server TEMPDB: /f mode to change TEMPDB

To remove or re-size any files belonging to TEMPDB:

net stop MSSQLSERVER

NET START MSSQLSERVER /f /mSQLCMD

PS C:\tmp> sqlcmd -S SERVER -E

use TEMPDB

go

DBCC SHRINKFILE (temp5, EMPTYFILE);

USE master

GO

ALTER DATABASE tempdb REMOVE FILE temp5;

go