use master
go
set ANSI_DEFAULTS on
go
-- ======================================

-- create tempdb files used when the benchmark is running

alter database tempdb add file 	(name = 'tempdbR',
                                filename = 'T:\tempdbR.mdf',
                                size = 512000MB,
                                filegrowth = 10%)                                
go

ALTER database tempdb
add log file
( NAME = tempdblogR,
  FILENAME = 'T:\tempdblogR.ldf',
  SIZE = 128000 MB,
  FILEGROWTH = 10%,
  MAXSIZE = 200000 MB)
go
