During a SQL Server installation, I "thought" I specified location of tempdb on 'F:' and not 'C:', but I can see that although tempdb.mdf and templog.ldf are on 'F:', the 3 .ndf secondary data files are on 'C:'.
I'm thinking of moving the .ndf files by performing following steps:
ALTER DATABASE tempdb MODIFY FILE ( NAME = temp2 , FILENAME = 'F:\MSSQLData\temp2' ) ALTER DATABASE tempdb MODIFY FILE ( NAME = temp3 , FILENAME = 'F:\MSSQLData\temp3' ) ALTER DATABASE tempdb MODIFY FILE ( NAME = temp4 , FILENAME = 'F:\MSSQLData\temp4' )
- Stop SQL Server (the instance isn't doing anything currently).
- copy/paste the 3 .ndf files from their current C: location to the new F:\MSSQLData\ location
- Restart SQL Server.
- Check if it worked:
SELECT name, physical_name AS CurrentLocation, state_desc FROM sys.master_files WHERE database_id = DB_ID(N'tempdb');
Is that the best approach? The instance supports only 3 small databases (<10GB total).