Change location of TempDB files

--Verify path file tempdb
USE TempDB
GO
EXEC sp_helpfile
GO

--Change path tempdb data / log
USE master
GO
ALTER DATABASE TempDB MODIFY FILE
(NAME = tempdev, FILENAME = '<path/file.mdf>')
GO
ALTER DATABASE TempDB MODIFY FILE
(NAME = templog, FILENAME = '<path/file.ldf>')
GO

-- e.g. '<path/file.mdf>' -> 'e:\data\datatempdata.mdf'

This site uses Akismet to reduce spam. Learn how your comment data is processed.