How To Generate the Script to move the Temp db files in SQL Server
T SQL Script to Generate the TEMP db move
============================
USE master;
GO
DECLARE @newfilepath NVARCHAR(260) = ‘E:datanew’; — Update this with your new file path
DECLARE @stmt NVARCHAR(MAX) = ”;
SELECT @stmt += ‘ALTER DATABASE tempdb MODIFY FILE (NAME = ‘ + name + ‘, FILENAME = ”’ + @newfilepath + REPLACE(physical_name, ‘C:Program FilesMicrosoft SQL ServerMSSQL15.SQLHYD2019MSSQLDATA’, ”) + ”’) ‘ + CHAR(13)
FROM tempdb.sys.database_files;
PRINT @stmt
=============================