If you need to move the tempdb to another drive in SQL Server, use this SQL:
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
Don't forget to modify the paths according to your own server paths.
Welcome!
Braintapper is an open community for business intelligence professionals.
Ask and answer questions, post interesting social bookmarks, and job postings for free!
All you need to join is an OpenID, e-mail address and a nickname!
