How to change TempDB system Database files location?

Steps to change TempDB system Database files location :- 1) Check current file location of TempDB Exec SP_helpDB TempDB You can use below query as well for file location details. SELECT name, physical_name AS CurrentLocation, state_desc FROM sys.master_files WHERE database_id = DB_ID(‘TempDB’); 2) Execute Alter Database command with Modify Filename option on Tempdb System Database … Continue reading ?