-- Stored Procedure: dbo.BackupConfigUpdate
-- 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].[BackupConfigUpdate]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BackupConfigUpdate]
GO



CREATE PROCEDURE [dbo].[BackupConfigUpdate] 
 @DatabaseName varchar(128),
 @BackupServerName varchar(18),
 @BackupScheduleSet varchar(30),
 @IncludeRestore varchar(3) = '',
 @RestoreServerName varchar(128) = '',
 @BeforeBackupPackageName varchar(128) = '',
 @BeforeBackupPackageUNCFile varchar(255) = '',
 @BeforeBackupPackageGlobalVariables varchar(255) = '',
 @ArchivePackageName varchar(128) = '',
 @ArchivePackageUNCFile varchar(255) = '',
 @ArchivePackageGlobalVariables varchar(255) = '',
 @BackupPackageName varchar(128) = '',
 @BackupPackageUNCFile varchar(255) = '',
 @BackupPackageGlobalVariables varchar(255) = '',
 @AfterBackupPackageName varchar(128) = '',
 @AfterBackupPackageUNCFile varchar(255) = '',
 @AfterBackupPackageGlobalVariables varchar(255) = '',
 @BeforeRestorePackageName varchar(128) = '',
 @BeforeRestorePackageUNCFile varchar(255) = '',
 @BeforeRestorePackageGlobalVariables varchar(255) = '',
 @RestorePackageName varchar(128) = '',
 @RestorePackageUNCFile varchar(255) = '',
 @RestorePackageGlobalVariables varchar(255) = '',
 @AfterRestorePackageName varchar(128) = '',
 @AfterRestorePackageUNCFile varchar(255) = '',
 @AfterRestorePackageGlobalVariables varchar(255) = ''   
AS
/*******************************************************************************************************
* admin.dbo.BackupConfigUpdate 
* Creator:      Bill Wunder
* Date:   2-25-2003
*
* Project:      Backup - Restore
* Project Mgr: 
* Dev Contact: 
*
* Description: Update backup configuration data for a database\server\BackupSet (
* Notes: to change a primary key value delete the row and add a new one     
*
* Usage:
      EXECUTE admin.dbo.BackupConfigUpdate 
   @DatabaseName = 'admin',
   @BackupServerName = 'DEV_ZEUS',
   @BackupScheduleSet = 'One Time Incremental',
   @ArchivePackageName = 'Archive a Backup Device',
   @ArchivePackageUNCFile = '\\BILL2K\DTSPackages\Archive a Backup Device.dts',
   @ArchivePackageGlobalVariables = '/A"Backup Folder:8=\\BILL2K\BACKUPS\BILL2K" /A"Database Name:8=test" /A"Backup Format:8=sls"'
*
*
* Modifications:   
*         Developer Name     Date     Brief Description
*         ------------------ -------- ------------------------------------------------------------
*
********************************************************************************************************/

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

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

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


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

update admin.dbo.BackupConfig
 set IncludeRestore = case when @IncludeRestore = '' then IncludeRestore else @IncludeRestore end,
 RestoreServerName = case when @RestoreServerName = '' then RestoreServerName else @RestoreServerName end,
 BeforeBackupPackageName = case when @BeforeBackupPackageName = '' then BeforeBackupPackageName else @BeforeBackupPackageName end,
 BeforeBackupPackageUNCFile = case when @BeforeBackupPackageUNCFile = '' then BeforeBackupPackageUNCFile else @BeforeBackupPackageUNCFile end,
 BeforeBackupPackageGlobalVariables = case when @BeforeBackupPackageGlobalVariables = '' then BeforeBackupPackageGlobalVariables else @BeforeBackupPackageGlobalVariables end,
 ArchivePackageName = case when @ArchivePackageName = '' then ArchivePackageName else @ArchivePackageName end,
 ArchivePackageUNCFile = case when @ArchivePackageUNCFile = '' then ArchivePackageUNCFile else @ArchivePackageUNCFile end,
 ArchivePackageGlobalVariables = case when @ArchivePackageGlobalVariables = '' then ArchivePackageGlobalVariables else @ArchivePackageGlobalVariables end,
 BackupPackageName = case when @BackupPackageName = '' then BackupPackageName else @BackupPackageName end,
 BackupPackageUNCFile = case when @BackupPackageUNCFile = '' then BackupPackageUNCFile else @BackupPackageUNCFile end,
 BackupPackageGlobalVariables = case when @BackupPackageGlobalVariables = '' then BackupPackageGlobalVariables else @BackupPackageGlobalVariables end,
 AfterBackupPackageName = case when @AfterBackupPackageName = '' then AfterBackupPackageName else @AfterBackupPackageName end,
 AfterBackupPackageUNCFile = case when @AfterBackupPackageUNCFile = '' then AfterBackupPackageUNCFile else @AfterBackupPackageUNCFile end,
 AfterBackupPackageGlobalVariables = case when @AfterBackupPackageGlobalVariables = '' then AfterBackupPackageGlobalVariables else @AfterBackupPackageGlobalVariables end,
 BeforeRestorePackageName = case when @BeforeRestorePackageName = '' then BeforeRestorePackageName else @BeforeRestorePackageName end,
 BeforeRestorePackageUNCFile = case when @BeforeRestorePackageUNCFile = '' then BeforeRestorePackageUNCFile else @BeforeRestorePackageUNCFile end,
 BeforeRestorePackageGlobalVariables = case when @BeforeRestorePackageGlobalVariables = '' then BeforeRestorePackageGlobalVariables else @BeforeRestorePackageGlobalVariables end,
 RestorePackageName = case when @RestorePackageName = '' then RestorePackageName else @RestorePackageName end,
 RestorePackageUNCFile = case when @RestorePackageUNCFile = '' then RestorePackageUNCFile else @RestorePackageUNCFile end,
 RestorePackageGlobalVariables = case when @RestorePackageGlobalVariables = '' then RestorePackageGlobalVariables else @RestorePackageGlobalVariables end,
 AfterRestorePackageName = case when @AfterRestorePackageName = '' then AfterRestorePackageName else @AfterRestorePackageName end,
 AfterRestorePackageUNCFile = case when @AfterRestorePackageUNCFile = '' then AfterRestorePackageUNCFile else @AfterRestorePackageUNCFile end,
 AfterRestorePackageGlobalVariables = case when @AfterRestorePackageGlobalVariables  = '' then AfterRestorePackageGlobalVariables else @AfterRestorePackageGlobalVariables end
where DatabaseName = @DatabaseName
and BackupServerName = @BackupServerName
and BackupScheduleSet = @BackupScheduleSet



GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON 
GO