use master go Alter database tempdb modify file (name = tempdev, filename = 'E:\Sqltemp\tempdb.mdf') go Alter database tempdb modify file (name = templog, filename = 'E:\Sqltemp\templog.ldf') go Alter database tempdb modify file (name = tempdb2, filename = 'E:\Sqltemp\tempdb2.mdf') go Alter database tempdb modify file (name = tempdb3, filename = 'E:\Sqltemp\tempdb3.mdf') go Alter database tempdb modify file (name = tempdb4, filename = 'E:\Sqltemp\tempdb4.mdf') go