EXECUTE [dbo].[DatabaseBackup]
@Databases = 'APM', 
@Directory = N'\\ala7600nas02\Archive_Backup\SQL backup', 
@BackupType = 'FULL', 
@Verify = 'Y', 
@Compress = 'Y',
@CheckSum = 'Y',
@CleanupTime = 72
Хранилка при создании:
IF @Compress NOT IN ('Y','N') OR @Compress IS NULL OR (@Compress = 'Y' AND @BackupSoftware IS NULL AND NOT ((@Version >= 10 AND @Version < 10.5 AND SERVERPROPERTY('EngineEdition') = 3)
  OR (@Version >= 10.5 AND (SERVERPROPERTY('EngineEdition') = 3 OR SERVERPROPERTY('EditionID') IN (-1534726760, 284895786))))) OR (@Compress = 'N' AND @BackupSoftware 
  IS NOT NULL AND (@CompressionLevel IS NULL OR @CompressionLevel >= 1)) OR (@Compress = 'Y' AND @BackupSoftware IS NOT NULL AND @CompressionLevel = 0)
  BEGIN
    SET @ErrorMessage = 'The value for the parameter @Compress is not supported.' + CHAR(13) + CHAR(10) + ' '
    RAISERROR(@ErrorMessage,16,1) WITH NOWAIT
    SET @Error = @@ERROR
  END
Скрипт с помощника бэкапирования:
BACKUP DATABASE [DB] TO  DISK = N'Sourse.bak' WITH NOFORMAT, NOINIT,  NAME = N'Source', SKIP, NOREWIND, NOUNLOAD,  STATS = 10, CHECKSUM
GO
declare @backupSetId as int
select @backupSetId = position from msdb..backupset where database_name=N'Source' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N'Source' )
if @backupSetId is null begin raiserror(N'Verify failed. Backup information for database ''Source'' not found.', 16, 1) end
RESTORE VERIFYONLY FROM  DISK = N'Sourse.bak' WITH  FILE = @backupSetId,  NOUNLOAD,  NOREWIND
GO

use master
go
-- Удаляем процедуру, если она существует
if object_id ( 'dbo.BackupWithArchive', 'P' ) is not null
  drop procedure dbo.BackupWithArchive
go

create procedure dbo.BackupWithArchive
(
    @BackupCommand nvarchar (4000) = 'help' -- стандартные команды бэкапирования
  , @BackupFile    nvarchar (1024) -- имя Backup-файла
  , @ArchCommand   nvarchar (128)  = ' a -r -mx ' -- параметры архивирования
  , @ArchFile      nvarchar (1024) -- имя архива 
  , @DeleteAfterArchive bit = 0    -- удаление бэкапа после архивирования

)
as
set nocount on

declare @archiver nvarchar (256)
      , @cmd nvarchar (512)
      , @file_exists int
      , @error int
	  , @fileDate nvarchar(20)
    SELECT @fileDate = CONVERT(NVARCHAR(20),GETDATE(),112)     
  set @error = 0 
  -- Архиватор 7-zip  
  set @archiver = N'"C:\Program Files (x86)\7-Zip\7z.exe"'

  -- Список параметров архивирования
 
  if ( @BackupCommand = 'help' ) or ( @BackupCommand = '?' )
  begin
    set @cmd =  @archiver + ' -?'
    exec @error = master..xp_cmdshell @cmd
    select @error = @@error where @@error != 0
    return @error
  end

  -- Само Бэкапирование в динамике
  exec @error = master..sp_executesql @BackupCommand
  select @error = @@error where @@error != 0
  if ( @error != 0 ) 
    return @error

  -- Проверяем существование Backup-файла
  set @file_exists = 0
  exec @error = master..xp_fileexist @BackupFile, @file_exists out
  select @error = @@error where @@error != 0
  if ( @file_exists = 0 ) or ( @error != 0 ) 
  begin
    select 'Backup-файл не найден!'
    return @error 
  end

  -- Само архивирование
  set @cmd = @archiver + ' ' + @ArchCommand + ' ' + @ArchFile + ' ' + @BackupFile
  exec @error = master.dbo.xp_cmdshell @cmd
  select @error = @@error where @@error != 0
  if ( @error != 0 ) 
    return @error

  --Удаляем сам Бэкап
  if ( @DeleteAfterArchive = 1 )
  begin
    set @cmd = 'del ' + @BackupFile
    exec @error = master.dbo.xp_cmdshell @cmd
    select @error = @@error where @@error != 0
    return @error
  end

  return @error
go