Thursday, May 7, 2009

SQL Moving Tempdb

Moving Tempdb

I used MS SQL Server Manager Studio and ran this under Database Engine Query.

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

No comments:

Post a Comment