Move tempdb..?

[kenjoswe]

Hi all,

I would like to move tempdb from C:\ to D:\.
How can I do this?
Can I just detach database, move it to the new location, and then attach the database?

/Kent J.

 

[JayKusch]

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



Thanks

J. Kusch

 

[SQLBill]

Then stop and restart the SQL Server services. Every time the services are stopped and restarted, SQL Server 'rebuilds' the TEMPDB. That's when it will go to the new location.

-SQLBill