alter database tempdb modify file(name=tempdev, filename='v:\Device\TPCE_TempDB\tempdb.mdf', SIZE=10240MB, FILEGROWTH=10%, MAXSIZE=20480MB)
go
alter database tempdb modify file(name=templog, filename='v:\Device\TPCE_TempLog\templog.ldf', SIZE=10240MB, FILEGROWTH=10%, MAXSIZE=20480MB)
go

ALTER DATABASE tempdb ADD LOG FILE
(NAME=templog2, FILENAME='v:\Device\TPCE_TempLog\templog2.ldf', SIZE=10240MB, FILEGROWTH=10%, MAXSIZE=307200MB)
go

ALTER DATABASE tempdb ADD FILE
(NAME=tempdev01, FILENAME='v:\Device\tempdb01\tempdb01.mdf', SIZE=5120MB, FILEGROWTH=10%, MAXSIZE=307200MB),
(NAME=tempdev02, FILENAME='v:\Device\tempdb02\tempdb02.mdf', SIZE=5120MB, FILEGROWTH=10%, MAXSIZE=307200MB),
(NAME=tempdev03, FILENAME='v:\Device\tempdb03\tempdb03.mdf', SIZE=5120MB, FILEGROWTH=10%, MAXSIZE=307200MB),
(NAME=tempdev04, FILENAME='v:\Device\tempdb04\tempdb04.mdf', SIZE=5120MB, FILEGROWTH=10%, MAXSIZE=307200MB),
(NAME=tempdev05, FILENAME='v:\Device\tempdb05\tempdb05.mdf', SIZE=5120MB, FILEGROWTH=10%, MAXSIZE=307200MB),
(NAME=tempdev06, FILENAME='v:\Device\tempdb06\tempdb06.mdf', SIZE=5120MB, FILEGROWTH=10%, MAXSIZE=307200MB),
(NAME=tempdev07, FILENAME='v:\Device\tempdb07\tempdb07.mdf', SIZE=5120MB, FILEGROWTH=10%, MAXSIZE=307200MB),
(NAME=tempdev08, FILENAME='v:\Device\tempdb08\tempdb08.mdf', SIZE=5120MB, FILEGROWTH=10%, MAXSIZE=307200MB),
(NAME=tempdev09, FILENAME='v:\Device\tempdb09\tempdb09.mdf', SIZE=5120MB, FILEGROWTH=10%, MAXSIZE=307200MB),
(NAME=tempdev10, FILENAME='v:\Device\tempdb10\tempdb10.mdf', SIZE=5120MB, FILEGROWTH=10%, MAXSIZE=307200MB),
(NAME=tempdev11, FILENAME='v:\Device\tempdb11\tempdb11.mdf', SIZE=5120MB, FILEGROWTH=10%, MAXSIZE=307200MB),
(NAME=tempdev12, FILENAME='v:\Device\tempdb12\tempdb12.mdf', SIZE=5120MB, FILEGROWTH=10%, MAXSIZE=307200MB),
(NAME=tempdev13, FILENAME='v:\Device\tempdb13\tempdb13.mdf', SIZE=5120MB, FILEGROWTH=10%, MAXSIZE=307200MB),
(NAME=tempdev14, FILENAME='v:\Device\tempdb14\tempdb14.mdf', SIZE=5120MB, FILEGROWTH=10%, MAXSIZE=307200MB),
(NAME=tempdev15, FILENAME='v:\Device\tempdb15\tempdb15.mdf', SIZE=5120MB, FILEGROWTH=10%, MAXSIZE=307200MB),
(NAME=tempdev16, FILENAME='v:\Device\tempdb16\tempdb16.mdf', SIZE=5120MB, FILEGROWTH=10%, MAXSIZE=307200MB),
(NAME=tempdev17, FILENAME='v:\Device\tempdb17\tempdb17.mdf', SIZE=5120MB, FILEGROWTH=10%, MAXSIZE=307200MB),
(NAME=tempdev18, FILENAME='v:\Device\tempdb18\tempdb18.mdf', SIZE=5120MB, FILEGROWTH=10%, MAXSIZE=307200MB),
(NAME=tempdev19, FILENAME='v:\Device\tempdb19\tempdb19.mdf', SIZE=5120MB, FILEGROWTH=10%, MAXSIZE=307200MB),
(NAME=tempdev20, FILENAME='v:\Device\tempdb20\tempdb20.mdf', SIZE=5120MB, FILEGROWTH=10%, MAXSIZE=307200MB),
(NAME=tempdev21, FILENAME='v:\Device\tempdb21\tempdb21.mdf', SIZE=5120MB, FILEGROWTH=10%, MAXSIZE=307200MB),
(NAME=tempdev22, FILENAME='v:\Device\tempdb22\tempdb22.mdf', SIZE=5120MB, FILEGROWTH=10%, MAXSIZE=307200MB)
go
