If you need to move the tempdb database after SQL Server is first installed,
run this script to move it to a more appropriate location:

USE master 
go 

ALTER DATABASE tempdb MODIFY FILE (NAME = tempdev, FILENAME = 'E:\tempdbname.mdf') 
go 

ALTER DATABASE tempdb MODIFY FILE (NAME = templog, FILENAME = 'E:\templogname.ldf') 
go

• NAME refers to the logical name of the tempdb database and log files.
• FILENAME refers to the new location of the tempdb files. 
• You must restart the mssqlserver service before it takes affect.