-- Stored Procedure: dbo.BackupConfigInsert -- 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].[BackupConfigInsert]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[BackupConfigInsert] GO CREATE PROCEDURE [dbo].[BackupConfigInsert] @DatabaseName varchar(128), @BackupServerName varchar(18), @BackupScheduleSet varchar(30), @IncludeRestore varchar(3) = 'no', @RestoreServerName varchar(128) = NULL, @BeforeBackupPackageName varchar(128) = NULL, @BeforeBackupPackageUNCFile varchar(255) = NULL, @BeforeBackupPackageGlobalVariables varchar(255) = NULL, @ArchivePackageName varchar(128) = NULL, @ArchivePackageUNCFile varchar(255) = NULL, @ArchivePackageGlobalVariables varchar(255) = NULL, @BackupPackageName varchar(128) = NULL, @BackupPackageUNCFile varchar(255) = NULL, @BackupPackageGlobalVariables varchar(255) = NULL, @AfterBackupPackageName varchar(128) = NULL, @AfterBackupPackageUNCFile varchar(255) = NULL, @AfterBackupPackageGlobalVariables varchar(255) = NULL, @BeforeRestorePackageName varchar(128) = NULL, @BeforeRestorePackageUNCFile varchar(255) = NULL, @BeforeRestorePackageGlobalVariables varchar(255) = NULL, @RestorePackageName varchar(128) = NULL, @RestorePackageUNCFile varchar(255) = NULL, @RestorePackageGlobalVariables varchar(255) = NULL, @AfterRestorePackageName varchar(128) = NULL, @AfterRestorePackageUNCFile varchar(255) = NULL, @AfterRestorePackageGlobalVariables varchar(255) = NULL AS /******************************************************************************************************* * admin.dbo.BackupConfigInsert * Creator: Bill Wunder * Date: 2-25-2003 * * Project: Backup - Restore * Project Mgr: * Dev Contact: * * Description: Insert backup onfiguration data for a database * Notes: * * Usage: EXECUTE BackupConfigInsert @DatabaseName = 'admin', @BakcupServerName = 'BILL2K', @BackupScheduleSet = 'One Time Incremental', @BackupPackageName = 'Differential Backup of a Database', @BackupPackageUNCFileName = '\\BILL2K\DTSPackages\Differential Backup of a Database.dts', @BackupPackageGlobalVariables = '/A"Backup Folder:8=\\BILL2K\Backups\BILL2K" /A"Source SQL Server:8=BILLK" /A"Database Name:8=admin" /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 --------------------------------------------- insert admin.dbo.BackupConfig (DatabaseName, BackupServerName, BackupScheduleSet, IncludeRestore, RestoreServerName, BeforeBackupPackageName, BeforeBackupPackageUNCFile, BeforeBackupPackageGlobalVariables, ArchivePackageName, ArchivePackageUNCFile, ArchivePackageGlobalVariables, BackupPackageName, BackupPackageUNCFile, BackupPackageGlobalVariables, AfterBackupPackageName, AfterBackupPackageUNCFile, AfterBackupPackageGlobalVariables, BeforeRestorePackageName, BeforeRestorePackageUNCFile, BeforeRestorePackageGlobalVariables, RestorePackageName, RestorePackageUNCFile, RestorePackageGlobalVariables, AfterRestorePackageName, AfterRestorePackageUNCFile, AfterRestorePackageGlobalVariables) values (@DatabaseName, @BackupServerName, @BackupScheduleSet, @IncludeRestore, @RestoreServerName, @BeforeBackupPackageName, @BeforeBackupPackageUNCFile, @BeforeBackupPackageGlobalVariables, @ArchivePackageName, @ArchivePackageUNCFile, @ArchivePackageGlobalVariables, @BackupPackageName, @BackupPackageUNCFile, @BackupPackageGlobalVariables, @AfterBackupPackageName, @AfterBackupPackageUNCFile, @AfterBackupPackageGlobalVariables, @BeforeRestorePackageName, @BeforeRestorePackageUNCFile, @BeforeRestorePackageGlobalVariables, @RestorePackageName, @RestorePackageUNCFile, @RestorePackageGlobalVariables, @AfterRestorePackageName, @AfterRestorePackageUNCFile, @AfterRestorePackageGlobalVariables) GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO