SQL Server Script: Move TempDB Script

Move TempDB Script


ALTER DATABASE tempdb
MODIFY FILE(NAME='tempdev', FILENAME='\tempdb.mdf')
ALTER DATABASE tempdb
MODIFY FILE(NAME='templog', FILENAME='\templog.ldf')


Replace with the file path of the new location you want the TempDB files to be... If you have multiple tempDB files, you will need to run create the MODIFY FILE line for each file name...

You must restart sql server for this to take effect!