move_database_files.sql

--Find the location of the files currently 

SELECT name, physical_name AS current_file_location
FROM sys.master_files

--Move this for all files for the database, mdf, ldf & ndf files

USE master; --do this all from the master
ALTER DATABASE [tempdb]
MODIFY FILE 
(
	name='tempdev',
    filename='D:\tempdb.mdf'
); --Filename is new location

USE master; --do this all from the master
ALTER DATABASE [tempdb]
MODIFY FILE 
(
	name='temp2',
    filename='D:\tempdb_mssql_2.ndf'
); --Filename is new location

USE master; --do this all from the master
ALTER DATABASE [tempdb]
MODIFY FILE 
(
	name='temp3',
    filename='D:\tempdb_mssql_3.ndf'
); --Filename is new location

USE master; --do this all from the master
ALTER DATABASE [tempdb]
MODIFY FILE 
(
	name='temp4',
    filename='D:\tempdb_mssql_4.ndf'
); --Filename is new location

USE master; --do this all from the master
ALTER DATABASE [tempdb]
MODIFY FILE 
(
	name='temp5',
    filename='D:\tempdb_mssql_5.ndf'
); --Filename is new location

USE master; --do this all from the master
ALTER DATABASE [tempdb]
MODIFY FILE 
(
	name='temp6',
    filename='D:\tempdb_mssql_6.ndf'
); --Filename is new location

USE master; --do this all from the master
ALTER DATABASE [tempdb]
MODIFY FILE 
(
	name='temp7',
    filename='D:\tempdb_mssql_7.ndf'
); --Filename is new location

USE master; --do this all from the master
ALTER DATABASE [tempdb]
MODIFY FILE 
(
	name='temp8',
    filename='D:\tempdb_mssql_8.ndf'
); --Filename is new location


USE master; --do this all from the master
ALTER DATABASE [tempdb]
MODIFY FILE 
(
	name='templog',
    filename='L:\templog_log.ldf'
); --Filename is new location