Search This Blog

Friday, January 16, 2009

Move location of SQL Server temp database

Run this query:

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

Then,restart MSSQLServer service

No comments: