-- Stored Procedure: dbo.BackupConfigDelete
-- Bill Wunder

use admin
GO
SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BackupConfigDelete]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BackupConfigDelete]
GO



CREATE PROCEDURE [dbo].[BackupConfigDelete] 
 @BackupScheduleSet varchar(30),
 @DatabaseName varchar(128) = 'ALL',
 @BackupServerName varchar(18) = 'ALL'
AS
/*******************************************************************************************************
* admin.dbo.BackupConfigDelete 
* Creator:      Bill Wunder
* Date:   2-25-2003
*
* Project:      Backup - Restore
* Project Mgr: 
* Dev Contact: 
*
* Description: Delete backup configuration data for BackupSet or for a specified database/server only
* Notes:  
*
* Usage:
      EXECUTE admin.dbo.BackupConfigDelete 
   @BackupScheduleSet = 'One Time Incremental'
*
*
* Modifications:   
*         Developer Name     Date     Brief Description
*         ------------------ -------- ------------------------------------------------------------
*
********************************************************************************************************/

---------------------------------------------
-- declare variables
---------------------------------------------

---------------------------------------------
-- create temp tables
---------------------------------------------

---------------------------------------------
-- set session
---------------------------------------------
SET NOCOUNT ON


---------------------------------------------
-- body of stored procedure
---------------------------------------------

delete admin.dbo.BackupConfig
where (DatabaseName = @DatabaseName or @DatabaseName = 'ALL')
and (BackupServerName = @BackupServerName or @BackupServerName = 'ALL')
and BackupScheduleSet = @BackupScheduleSet



GO
SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO