Moving TempDB database on SQL 2005
By Michael on Thursday 2 July 2009, 22:42 - MS-SQL2005 - Permalink
Moving TempDB database on SQL 2005
When you configure your SQL server server it's important to move your TempDB databse on another disk, to do taht follow steps below:
Use the following query:
use master ;
go
alter database tempdb modify file (name= tempdev, filename= 'target path\tempdb.mdf') ;
go ;
Repeat this command for each files linked on this DB.
Note: If you move on sql cluster, check that the target disk is include in the dependencies of the sql service.