SQL Server: move TempDB path


Used many times but often forgotten...




use master
go
alter
database tempdb modify file (name = tempdev, filename = '[new_path]\tempdb.mdf')
go
alter database
tempdb modify file (name = templog, filename = '[new_path]\templog.ldf')
Tags:

About author

Vittorio Pavesi