use master
go
set ANSI_DEFAULTS on
go

-- create tempdb files needed for a successful database load

alter database tempdb add file 	
		(name = 'tempdb1',
                                filename = 'c:\mp\t1\tempdb1.mdf',
                                size = 500000MB,
                                filegrowth = 10%),
		(name = 'tempdb2',
                                filename = 'c:\mp\t2\tempdb2.mdf',
                                size = 500000MB,
                                filegrowth = 10%),
		(name = 'tempdb3',
                                filename = 'c:\mp\t3\tempdb3.mdf',
                                size = 500000MB,
                                filegrowth = 10%),
        (name = 'tempdb4',
                                filename = 'c:\mp\t4\tempdb4.mdf',
                                size = 500000MB,
                                filegrowth = 10%),          
        (name = 'tempdb5',
                                filename = 'c:\mp\t1\tempdb5.mdf',
                                size = 500000MB,
                                filegrowth = 10%),
        (name = 'tempdb6',
                                filename = 'c:\mp\t2\tempdb6.mdf',
                                size = 500000MB,
                                filegrowth = 10%),
        (name = 'tempdb7',
                                filename = 'c:\mp\t3\tempdb7.mdf',
                                size = 500000MB,
                                filegrowth = 10%),
		(name = 'tempdb8',
                                filename = 'c:\mp\t4\tempdb8.mdf',
                                size = 500000MB,
                                filegrowth = 10%),
		(name = 'tempdb9',
                                filename = 'c:\mp\t1\tempdb9.mdf',
                                size = 500000MB,
                                filegrowth = 10%),
		(name = 'tempdb10',
                                filename = 'c:\mp\t2\tempdb10.mdf',
                                size = 500000MB,
                                filegrowth = 10%),
		(name = 'tempdb11',
                                filename = 'c:\mp\t3\tempdb11.mdf',
                                size = 500000MB,
                                filegrowth = 10%),
        (name = 'tempdb12',
                                filename = 'c:\mp\t4\tempdb12.mdf',
                                size = 500000MB,
                                filegrowth = 10%),
        (name = 'tempdb13',
                                filename = 'c:\mp\t1\tempdb13.mdf',
                                size = 500000MB,
                                filegrowth = 10%),
		(name = 'tempdb14',
                                filename = 'c:\mp\t2\tempdb14.mdf',
                                size = 500000MB,
                                filegrowth = 10%),
		(name = 'tempdb15',
                                filename = 'c:\mp\t3\tempdb15.mdf',
                                size = 500000MB,
                                filegrowth = 10%),
		(name = 'tempdb16',
                                filename = 'c:\mp\t4\tempdb16.mdf',
                                size = 500000MB,
                                filegrowth = 10%),
		(name = 'tempdb17',
                                filename = 'c:\mp\t1\tempdb17.mdf',
                                size = 500000MB,
                                filegrowth = 10%),
		(name = 'tempdb18',
                                filename = 'c:\mp\t2\tempdb18.mdf',
                                size = 500000MB,
                                filegrowth = 10%),
		(name = 'tempdb19',
                                filename = 'c:\mp\t3\tempdb19.mdf',
                                size = 500000MB,
                                filegrowth = 10%),
		(name = 'tempdb20',
                                filename = 'c:\mp\t4\tempdb20.mdf',
                                size = 500000MB,
                                filegrowth = 10%),
		(name = 'tempdb21',
                                filename = 'c:\mp\t1\tempdb21.mdf',
                                size = 500000MB,
                                filegrowth = 10%),
		(name = 'tempdb22',
                                filename = 'c:\mp\t2\tempdb22.mdf',
                                size = 500000MB,
                                filegrowth = 10%),
		(name = 'tempdb23',
                                filename = 'c:\mp\t3\tempdb23.mdf',
                                size = 500000MB,
                                filegrowth = 10%),
		(name = 'tempdb24',
                                filename = 'c:\mp\t4\tempdb24.mdf',
                                size = 500000MB,
                                filegrowth = 10%)

go
ALTER database tempdb
add log file
( NAME = tempdblogL,
  --FILENAME = 'c:\mp\t3\tempdblogL.ldf',
  FILENAME = 'T:\tempdblogL.ldf',
  SIZE = 500000 MB,
  FILEGROWTH = 10%)
--  ,MAXSIZE = 150000 MB)
go

--go
ALTER database tempdb
add log file
( NAME = tempdblogL2,
 FILENAME = 'c:\mp\xt1\tempdblogL2.ldf',
  SIZE = 500000 MB,
  FILEGROWTH = 10%)
--  MAXSIZE = 500000 MB)
go