Skip to main content

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' )

Comments