--  File:     DROPBACKUPDEVB.SQL 
--            Microsoft TPC-E Benchmark Kit
--  Purpose:  Drops tpcc database Backup Devices


use master
go

--  drop backup devices

exec sp_dropdevice 'tpceback1A'
go
exec sp_dropdevice 'tpceback2A'
go
exec sp_dropdevice 'tpceback3A'
go
exec sp_dropdevice 'tpceback4A'
go
exec sp_dropdevice 'tpceback5A'
go
exec sp_dropdevice 'tpceback6A'
go
exec sp_dropdevice 'tpceback7A'
go
exec sp_dropdevice 'tpceback8A'
go
exec sp_dropdevice 'tpceback9A'
go
exec sp_dropdevice 'tpceback10A'
go
exec sp_dropdevice 'tpceback11A'
go
exec sp_dropdevice 'tpceback12A'
go
exec sp_dropdevice 'tpceback13A'
go
exec sp_dropdevice 'tpceback14A'
go
exec sp_dropdevice 'tpceback15A'
go
exec sp_dropdevice 'tpceback16A'
go

exec sp_dropdevice 'tpceback1B'
go
exec sp_dropdevice 'tpceback2B'
go
exec sp_dropdevice 'tpceback3B'
go
exec sp_dropdevice 'tpceback4B'
go
exec sp_dropdevice 'tpceback5B'
go
exec sp_dropdevice 'tpceback6B'
go
exec sp_dropdevice 'tpceback7B'
go
exec sp_dropdevice 'tpceback8B'
go
exec sp_dropdevice 'tpceback9B'
go
exec sp_dropdevice 'tpceback10B'
go
exec sp_dropdevice 'tpceback11B'
go
exec sp_dropdevice 'tpceback12B'
go
exec sp_dropdevice 'tpceback13B'
go
exec sp_dropdevice 'tpceback14B'
go
exec sp_dropdevice 'tpceback15B'
go
exec sp_dropdevice 'tpceback16B'
go

exec sp_dropdevice 'tpceback1C'
go
exec sp_dropdevice 'tpceback2C'
go
exec sp_dropdevice 'tpceback3C'
go
exec sp_dropdevice 'tpceback4C'
go
exec sp_dropdevice 'tpceback5C'
go
exec sp_dropdevice 'tpceback6C'
go
exec sp_dropdevice 'tpceback7C'
go
exec sp_dropdevice 'tpceback8C'
go
exec sp_dropdevice 'tpceback9C'
go
exec sp_dropdevice 'tpceback10C'
go
exec sp_dropdevice 'tpceback11C'
go
exec sp_dropdevice 'tpceback12C'
go
exec sp_dropdevice 'tpceback13C'
go
exec sp_dropdevice 'tpceback14C'
go
exec sp_dropdevice 'tpceback15C'
go
exec sp_dropdevice 'tpceback16C'
go

exec sp_dropdevice 'tpceback1D'
go
exec sp_dropdevice 'tpceback2D'
go
exec sp_dropdevice 'tpceback3D'
go
exec sp_dropdevice 'tpceback4D'
go
exec sp_dropdevice 'tpceback5D'
go
exec sp_dropdevice 'tpceback6D'
go
exec sp_dropdevice 'tpceback7D'
go
exec sp_dropdevice 'tpceback8D'
go
exec sp_dropdevice 'tpceback9D'
go
exec sp_dropdevice 'tpceback10D'
go
exec sp_dropdevice 'tpceback11D'
go
exec sp_dropdevice 'tpceback12D'
go
exec sp_dropdevice 'tpceback13D'
go
exec sp_dropdevice 'tpceback14D'
go
exec sp_dropdevice 'tpceback15D'
go
exec sp_dropdevice 'tpceback16D'
go

exec sp_dropdevice 'tpceback1E'
go
exec sp_dropdevice 'tpceback2E'
go
exec sp_dropdevice 'tpceback3E'
go
exec sp_dropdevice 'tpceback4E'
go
exec sp_dropdevice 'tpceback5E'
go
exec sp_dropdevice 'tpceback6E'
go
exec sp_dropdevice 'tpceback7E'
go
exec sp_dropdevice 'tpceback8E'
go
exec sp_dropdevice 'tpceback9E'
go
exec sp_dropdevice 'tpceback10E'
go
exec sp_dropdevice 'tpceback11E'
go
exec sp_dropdevice 'tpceback12E'
go
exec sp_dropdevice 'tpceback13E'
go
exec sp_dropdevice 'tpceback14E'
go
exec sp_dropdevice 'tpceback15E'
go
exec sp_dropdevice 'tpceback16E'
go

exec sp_dropdevice 'tpceback1F'
go
exec sp_dropdevice 'tpceback2F'
go
exec sp_dropdevice 'tpceback3F'
go
exec sp_dropdevice 'tpceback4F'
go
exec sp_dropdevice 'tpceback5F'
go
exec sp_dropdevice 'tpceback6F'
go
exec sp_dropdevice 'tpceback7F'
go
exec sp_dropdevice 'tpceback8F'
go
exec sp_dropdevice 'tpceback9F'
go
exec sp_dropdevice 'tpceback10F'
go
exec sp_dropdevice 'tpceback11F'
go
exec sp_dropdevice 'tpceback12F'
go
exec sp_dropdevice 'tpceback13F'
go
exec sp_dropdevice 'tpceback14F'
go
exec sp_dropdevice 'tpceback15F'
go
exec sp_dropdevice 'tpceback16F'
go



--sp_helpdevice