Modify the location of tempdb

with this script you can modify the Tempdb location, after that you need to do
1) Delete the old data and log file for tempdb
2) Recycle the SQL service.


USE master;
GO
ALTER DATABASE Tempdb MODIFY FILE
(NAME = TempDev,SIZE = 2050MB, FILEGROWTH = 256MB, FileName = 'S:\MP4Data\MSSQL2005\Data\tempdb.mdf');
GO

ALTER Database Tempdb MODIFY File
(Name = Templog, SIZE = 6154mb, FILEGROWTH = 256MB, FileName = 'S:\MP1Log\MSSQL2005\log\templog.ldf');
GO

Alter Database Tempdb add file
(name='TempData1',
FILENAME = 'S:\MP4Data\MSSQL2005\Data\TempData1.ndf',
SIZE = 2050MB,
FILEGROWTH = 256MB)

Alter Database Tempdb add file
(name='TempData2',
FILENAME = 'S:\MP4Data\MSSQL2005\Data\TempData2.ndf',
SIZE = 2050MB,
FILEGROWTH = 256MB)

Alter Database Tempdb add file
(name='TempData3',
FILENAME = 'S:\MP4Data\MSSQL2005\Data\TempData3.ndf',
SIZE = 2050MB,
FILEGROWTH = 256MB)

Alter Database Tempdb add file
(name='TempData4',
FILENAME = 'S:\MP4Data\MSSQL2005\Data\TempData4.ndf',
SIZE = 2050MB,
FILEGROWTH = 256MB)

Alter Database Tempdb add file
(name='TempData5',
FILENAME = 'S:\MP4Data\MSSQL2005\Data\TempData5.ndf',
SIZE = 2050MB,
FILEGROWTH = 256MB)

Alter Database Tempdb add file
(name='TempData6',
FILENAME = 'S:\MP4Data\MSSQL2005\Data\TempData6.ndf',
SIZE = 2050MB,
FILEGROWTH = 256MB)