You are here:Home » tsql » Move Tempdb to other location

Move Tempdb to other location

ALTER DATABASE tempdb
MODIFY FILE ( NAME = templog , FILENAME = 'f:\sql2000\templog.ldf' )

ALTER DATABASE tempdb
MODIFY FILE ( NAME = tempdev , FILENAME = 'f:\sql2000\tempdev.mdf' )