--  File:     BACKUPDEVB.SQL 
--            Microsoft TPC-E Benchmark Kit
--  Purpose:  Creates tpcc database Backup Devices


use master
go

--  create backup devices

exec sp_addumpdevice 'disk','tpceback1A','c:\mp\bk1\tpceback1A_2500k.dmp'
go
exec sp_addumpdevice 'disk','tpceback2A','c:\mp\bk2\tpceback2A_2500k.dmp'
go
exec sp_addumpdevice 'disk','tpceback3A','c:\mp\bk3\tpceback3A_2500k.dmp'
go
exec sp_addumpdevice 'disk','tpceback4A','c:\mp\bk1\tpceback4A_2500k.dmp'
go
exec sp_addumpdevice 'disk','tpceback5A','c:\mp\bk2\tpceback5A_2500k.dmp'
go
exec sp_addumpdevice 'disk','tpceback6A','c:\mp\bk3\tpceback6A_2500k.dmp'
go
exec sp_addumpdevice 'disk','tpceback7A','c:\mp\bk1\tpceback7A_2500k.dmp'
go
exec sp_addumpdevice 'disk','tpceback8A','c:\mp\bk2\tpceback8A_2500k.dmp'
go
exec sp_addumpdevice 'disk','tpceback9A','c:\mp\bk3\tpceback9A_2500k.dmp'
go
exec sp_addumpdevice 'disk','tpceback10A','c:\mp\bk1\tpceback10A_2500k.dmp'
go
exec sp_addumpdevice 'disk','tpceback11A','c:\mp\bk2\tpceback11A_2500k.dmp'
go
exec sp_addumpdevice 'disk','tpceback12A','c:\mp\bk3\tpceback12A_2500k.dmp'
go
exec sp_addumpdevice 'disk','tpceback13A','c:\mp\bk1\tpceback13A_2500k.dmp'
go
exec sp_addumpdevice 'disk','tpceback14A','c:\mp\bk2\tpceback14A_2500k.dmp'
go
exec sp_addumpdevice 'disk','tpceback15A','c:\mp\bk3\tpceback15A_2500k.dmp'
go
exec sp_addumpdevice 'disk','tpceback16A','c:\mp\bk1\tpceback16A_2500k.dmp'
go

exec sp_addumpdevice 'disk','tpceback1B','c:\mp\bk1\tpceback1B_2500k.dmp'
go
exec sp_addumpdevice 'disk','tpceback2B','c:\mp\bk2\tpceback2B_2500k.dmp'
go
exec sp_addumpdevice 'disk','tpceback3B','c:\mp\bk3\tpceback3B_2500k.dmp'
go
exec sp_addumpdevice 'disk','tpceback4B','c:\mp\bk1\tpceback4B_2500k.dmp'
go
exec sp_addumpdevice 'disk','tpceback5B','c:\mp\bk2\tpceback5B_2500k.dmp'
go
exec sp_addumpdevice 'disk','tpceback6B','c:\mp\bk3\tpceback6B_2500k.dmp'
go
exec sp_addumpdevice 'disk','tpceback7B','c:\mp\bk1\tpceback7B_2500k.dmp'
go
exec sp_addumpdevice 'disk','tpceback8B','c:\mp\bk2\tpceback8B_2500k.dmp'
go
exec sp_addumpdevice 'disk','tpceback9B','c:\mp\bk3\tpceback9B_2500k.dmp'
go
exec sp_addumpdevice 'disk','tpceback10B','c:\mp\bk1\tpceback10B_2500k.dmp'
go
exec sp_addumpdevice 'disk','tpceback11B','c:\mp\bk2\tpceback11B_2500k.dmp'
go
exec sp_addumpdevice 'disk','tpceback12B','c:\mp\bk3\tpceback12B_2500k.dmp'
go
exec sp_addumpdevice 'disk','tpceback13B','c:\mp\bk1\tpceback13B_2500k.dmp'
go
exec sp_addumpdevice 'disk','tpceback14B','c:\mp\bk2\tpceback14B_2500k.dmp'
go
exec sp_addumpdevice 'disk','tpceback15B','c:\mp\bk3\tpceback15B_2500k.dmp'
go
exec sp_addumpdevice 'disk','tpceback16B','c:\mp\bk2\tpceback16B_2500k.dmp'
go

exec sp_addumpdevice 'disk','tpceback1C','c:\mp\bk1\tpceback1C_2500k.dmp'
go
exec sp_addumpdevice 'disk','tpceback2C','c:\mp\bk2\tpceback2C_2500k.dmp'
go
exec sp_addumpdevice 'disk','tpceback3C','c:\mp\bk3\tpceback3C_2500k.dmp'
go
exec sp_addumpdevice 'disk','tpceback4C','c:\mp\bk1\tpceback4C_2500k.dmp'
go
exec sp_addumpdevice 'disk','tpceback5C','c:\mp\bk2\tpceback5C_2500k.dmp'
go
exec sp_addumpdevice 'disk','tpceback6C','c:\mp\bk3\tpceback6C_2500k.dmp'
go
exec sp_addumpdevice 'disk','tpceback7C','c:\mp\bk1\tpceback7C_2500k.dmp'
go
exec sp_addumpdevice 'disk','tpceback8C','c:\mp\bk2\tpceback8C_2500k.dmp'
go
exec sp_addumpdevice 'disk','tpceback9C','c:\mp\bk3\tpceback9C_2500k.dmp'
go
exec sp_addumpdevice 'disk','tpceback10C','c:\mp\bk1\tpceback10C_2500k.dmp'
go
exec sp_addumpdevice 'disk','tpceback11C','c:\mp\bk2\tpceback11C_2500k.dmp'
go
exec sp_addumpdevice 'disk','tpceback12C','c:\mp\bk3\tpceback12C_2500k.dmp'
go
exec sp_addumpdevice 'disk','tpceback13C','c:\mp\bk1\tpceback13C_2500k.dmp'
go
exec sp_addumpdevice 'disk','tpceback14C','c:\mp\bk2\tpceback14C_2500k.dmp'
go
exec sp_addumpdevice 'disk','tpceback15C','c:\mp\bk3\tpceback15C_2500k.dmp'
go
exec sp_addumpdevice 'disk','tpceback16C','c:\mp\bk3\tpceback16C_2500k.dmp'
go

exec sp_addumpdevice 'disk','tpceback1D','c:\mp\bk1\tpceback1D_2500k.dmp'
go
exec sp_addumpdevice 'disk','tpceback2D','c:\mp\bk2\tpceback2D_2500k.dmp'
go
exec sp_addumpdevice 'disk','tpceback3D','c:\mp\bk3\tpceback3D_2500k.dmp'
go
exec sp_addumpdevice 'disk','tpceback4D','c:\mp\bk1\tpceback4D_2500k.dmp'
go
exec sp_addumpdevice 'disk','tpceback5D','c:\mp\bk2\tpceback5D_2500k.dmp'
go
exec sp_addumpdevice 'disk','tpceback6D','c:\mp\bk3\tpceback6D_2500k.dmp'
go
exec sp_addumpdevice 'disk','tpceback7D','c:\mp\bk1\tpceback7D_2500k.dmp'
go
exec sp_addumpdevice 'disk','tpceback8D','c:\mp\bk2\tpceback8D_2500k.dmp'
go
exec sp_addumpdevice 'disk','tpceback9D','c:\mp\bk3\tpceback9D_2500k.dmp'
go
exec sp_addumpdevice 'disk','tpceback10D','c:\mp\bk1\tpceback10D_2500k.dmp'
go
exec sp_addumpdevice 'disk','tpceback11D','c:\mp\bk2\tpceback11D_2500k.dmp'
go
exec sp_addumpdevice 'disk','tpceback12D','c:\mp\bk3\tpceback12D_2500k.dmp'
go
exec sp_addumpdevice 'disk','tpceback13D','c:\mp\bk1\tpceback13D_2500k.dmp'
go
exec sp_addumpdevice 'disk','tpceback14D','c:\mp\bk2\tpceback14D_2500k.dmp'
go
exec sp_addumpdevice 'disk','tpceback15D','c:\mp\bk3\tpceback15D_2500k.dmp'
go
exec sp_addumpdevice 'disk','tpceback16D','c:\mp\bk1\tpceback16D_2500k.dmp'
go




--sp_helpdevice
