--  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_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback2A','c:\mp\bk2\tpceback2A_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback3A','c:\mp\bk3\tpceback3A_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback4A','c:\mp\bk4\tpceback4A_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback5A','c:\mp\bk5\tpceback5A_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback6A','c:\mp\bk6\tpceback6A_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback7A','c:\mp\bk7\tpceback7A_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback8A','c:\mp\bk8\tpceback8A_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback9A','c:\mp\bk9\tpceback9A_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback10A','c:\mp\bk10\tpceback10A_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback11A','c:\mp\bk11\tpceback11A_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback12A','c:\mp\bk12\tpceback12A_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback13A','c:\mp\bk13\tpceback13A_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback14A','c:\mp\bk14\tpceback14A_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback15A','c:\mp\bk15\tpceback15A_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback16A','c:\mp\bk16\tpceback16A_5750k.dmp'
go

exec sp_addumpdevice 'disk','tpceback1B','c:\mp\bk1\tpceback1B_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback2B','c:\mp\bk2\tpceback2B_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback3B','c:\mp\bk3\tpceback3B_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback4B','c:\mp\bk4\tpceback4B_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback5B','c:\mp\bk5\tpceback5B_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback6B','c:\mp\bk6\tpceback6B_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback7B','c:\mp\bk7\tpceback7B_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback8B','c:\mp\bk8\tpceback8B_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback9B','c:\mp\bk9\tpceback9B_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback10B','c:\mp\bk10\tpceback10B_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback11B','c:\mp\bk11\tpceback11B_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback12B','c:\mp\bk12\tpceback12B_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback13B','c:\mp\bk13\tpceback13B_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback14B','c:\mp\bk14\tpceback14B_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback15B','c:\mp\bk15\tpceback15B_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback16B','c:\mp\bk16\tpceback16B_5750k.dmp'
go

exec sp_addumpdevice 'disk','tpceback1C','c:\mp\bk1\tpceback1C_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback2C','c:\mp\bk2\tpceback2C_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback3C','c:\mp\bk3\tpceback3C_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback4C','c:\mp\bk4\tpceback4C_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback5C','c:\mp\bk5\tpceback5C_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback6C','c:\mp\bk6\tpceback6C_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback7C','c:\mp\bk7\tpceback7C_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback8C','c:\mp\bk8\tpceback8C_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback9C','c:\mp\bk9\tpceback9C_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback10C','c:\mp\bk10\tpceback10C_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback11C','c:\mp\bk11\tpceback11C_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback12C','c:\mp\bk12\tpceback12C_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback13C','c:\mp\bk13\tpceback13C_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback14C','c:\mp\bk14\tpceback14C_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback15C','c:\mp\bk15\tpceback15C_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback16C','c:\mp\bk16\tpceback16C_5750k.dmp'
go

exec sp_addumpdevice 'disk','tpceback1D','c:\mp\bk1\tpceback1D_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback2D','c:\mp\bk2\tpceback2D_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback3D','c:\mp\bk3\tpceback3D_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback4D','c:\mp\bk4\tpceback4D_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback5D','c:\mp\bk5\tpceback5D_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback6D','c:\mp\bk6\tpceback6D_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback7D','c:\mp\bk7\tpceback7D_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback8D','c:\mp\bk8\tpceback8D_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback9D','c:\mp\bk9\tpceback9D_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback10D','c:\mp\bk10\tpceback10D_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback11D','c:\mp\bk11\tpceback11D_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback12D','c:\mp\bk12\tpceback12D_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback13D','c:\mp\bk13\tpceback13D_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback14D','c:\mp\bk14\tpceback14D_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback15D','c:\mp\bk15\tpceback15D_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback16D','c:\mp\bk16\tpceback16D_5750k.dmp'
go

exec sp_addumpdevice 'disk','tpceback1E','c:\mp\bk1\tpceback1E_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback2E','c:\mp\bk2\tpceback2E_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback3E','c:\mp\bk3\tpceback3E_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback4E','c:\mp\bk4\tpceback4E_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback5E','c:\mp\bk5\tpceback5E_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback6E','c:\mp\bk6\tpceback6E_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback7E','c:\mp\bk7\tpceback7E_5750k.dmp'
go
exec sp_addumpdevice 'disk','tpceback8E','c:\mp\bk8\tpceback8E_5750k.dmp'
go



--sp_helpdevice
