MS SQL Server - Moving temp DB location

Moving the temp DB location

The script below will move the temp db from its current location to the new location (highlighted). Please ensure you change the logical file name (also highlighted) .

use master
go
Alter database tempdb modify file (name = tempdev, filename = 'E:\Sqldata\tempdb.mdf')
go
Alter database tempdb modify file (name = templog, filename = 'E:\Sqldata\templog.ldf')
go


After running the above script you will need to restart the MS SQL Server Service for the changes to take effect.