<div>
Yes, you need to specify a separate command for every file. &nbsp;Then, when SQL Server cycles (stops and restarts), the tempdb files will be created in the new location. &nbsp;The old tempdb files will still be in the original location, you will have to delete them yourself.<br />
<br />
Btw, 16 is very likely too many tempdb data files. &nbsp;You need to review that as well.
</div>


Yes, you need to specify a separate command for every file.  Then, when SQL Server cycles (stops and restarts), the tempdb files will be created in the new location.  The old tempdb files will still be in the original location, you will have to delete them yourself.

Btw, 16 is very likely too many tempdb data files.  You need to review that as well.

<div>
<div class="content wysiwyg-content">
Hello Everyone,<br />
<br />
Our tempdb is made up of 16 different files. &nbsp;I need to move the tempdb to a different partition. &nbsp;I found the script below to move the tempdb, but I was not sure how to move all the multiple files. &nbsp;Should I add every file tempdev1, tempdev2, tempdev3...etc... to this script?<br />
<br />
Thanks,<br />
<br />
Bill<br />
<br />
use master<br />
go<br />
Alter database tempdb modify file (name = tempdev, filename = 'F:\program files\microsoft SQL server\tempdb.mdf')<br />
go<br />
Alter database tempdb modify file (name = templog, filename = 'F:\program files\microsoft SQL server\templog.ldf')<br />
go
</div>
</div>


Hello Everyone,

Our tempdb is made up of 16 different files.  I need to move the tempdb to a different partition.  I found the script below to move the tempdb, but I was not sure how to move all the multiple files.  Should I add every file tempdev1, tempdev2, tempdev3...etc... to this script?

Thanks,

Bill

use master
go
Alter database tempdb modify file (name = tempdev, filename = 'F:\program files\microsoft SQL server\tempdb.mdf')
go
Alter database tempdb modify file (name = templog, filename = 'F:\program files\microsoft SQL server\templog.ldf')
go

Sql Server 2012 - Moving multiple tempdb files to a different Partition

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.