All you have to do is to modify the path in the script and run it in a new query !


USE master
GO
ALTER DATABASE tempdb MODIFY FILE (NAME = tempdev, FILENAME = 'e:\tempdb01.mdf')
GO
ALTER DATABASE tempdb MODIFY FILE (NAME = templog, FILENAME = 'f:\tempdb01.ldf')
GO

NB: You have to restart SQL services once your done !

Tagged with:  

Comments are closed.