Move TempDB

Modified on Mon, 28 Sep at 8:17 PM

SELECT 'ALTER DATABASE tempdb MODIFY FILE (NAME = [' + f.name + '],'
    + ' FILENAME = ''E:\SQL\tempdb\' + f.name
    + CASE WHEN f.type = 1 THEN '.ldf' ELSE '.mdf' END
    + ''');'
FROM sys.master_files f
WHERE f.database_id = DB_ID(N'tempdb');

Then run those commands. You don't need to move the actual files. Just restart the SQL serice.