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\xt1\tempdb1.mdf',
                                size = 1000000MB,
                                filegrowth = 10%),
		(name = 'tempdb2',
                                filename = 'c:\mp\xt2\tempdb2.mdf',
                                size = 1000000MB,
                                filegrowth = 10%),
		(name = 'tempdb3',
                                filename = 'c:\mp\xt3\tempdb3.mdf',
                                size = 1000000MB,
                                filegrowth = 10%),
        (name = 'tempdb4',
                                filename = 'c:\mp\bk1\tempdb4.mdf',
                                size = 1000000MB,
                                filegrowth = 10%),          
        (name = 'tempdb5',
                                filename = 'c:\mp\bk2\tempdb5.mdf',
                                size = 1000000MB,
                                filegrowth = 10%),
        (name = 'tempdb6',
                                filename = 'c:\mp\bk3\tempdb6.mdf',
                                size = 1000000MB,
                                filegrowth = 10%)

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

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