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')
Share on Google Plus

About Vittorio Pavesi

    Blogger Comment
    Facebook Comment

0 comments: