[SQL] Temp DB folder move to new drive

Check current tempdb file location and status. Rerun this after moving the location to check. 

Use master

GO

SELECT 

name AS [LogicalName]

,physical_name AS [Location]

,state_desc AS [Status]

FROM sys.master_files

WHERE database_id = DB_ID(N'tempdb');

GO 

Try to move C:\MSSQL\DATA location. 

MSSQL 2008 version code

USE master;

GO

ALTER DATABASE tempdb 

MODIFY FILE (NAME = tempdb, FILENAME = 'C:\MSSQL\DATA\tempdb.mdf');

GO

ALTER DATABASE tempdb 

MODIFY FILE (NAME = templog, FILENAME = 'C:\MSSQL\DATA\templog.ldf');

GO

MSSQL 2014 and after version

USE master;

GO

ALTER DATABASE tempdb 

MODIFY FILE (NAME = tempdev, FILENAME = 'C:\MSSQL\DATA\tempdb.mdf');

GO

ALTER DATABASE tempdb 

MODIFY FILE (NAME = templog, FILENAME = 'C:\MSSQL\DATA\templog.ldf');

GO

" The new path will be used the next time the database is started. " will show after run. 

Restart your MSSQL. and check with file location.