DECLARE @LS_BackupJobId	AS uniqueidentifier 
DECLARE @LS_PrimaryId	AS uniqueidentifier 
DECLARE @SP_Add_RetCode	As int 


EXEC @SP_Add_RetCode = master.dbo.sp_add_log_shipping_primary_database 
		@database = N'mssql1c' 
		,@backup_directory = N'/u04/mssql/binlog' 
		,@backup_share = N'/u04/mssql/binlog' 
		,@backup_job_name = N'LSBackup_mssql1c' 
		,@backup_retention_period = 4320
		,@backup_compression = 2
		,@backup_threshold = 60 
		,@threshold_alert_enabled = 1
		,@history_retention_period = 5760 
		,@backup_job_id = @LS_BackupJobId OUTPUT 
		,@primary_id = @LS_PrimaryId OUTPUT 
		,@overwrite = 1 

    exec @retcode = sys.sp_MSgetlogshipagentpath @toolpath = @toolpath OUTPUT
    if @retcode != 0
    begin
            raiserror(32018, 16, 2)
            return 1
    end

EXEC @SP_Add_RetCode = master.dbo.sp_add_log_shipping_primary_database 
		@database = N'mytestdb' 
		,@backup_directory = N'/u01/mssql/backup' 
		,@backup_share = N'/u01/mssql/backup' 
		,@backup_job_name = N'LSBackup_mytestdb' 
		,@backup_retention_period = 4320
		,@backup_compression = 2
		,@backup_threshold = 60 
		,@threshold_alert_enabled = 1
		,@history_retention_period = 5760 
		,@backup_job_id = @LS_BackupJobId OUTPUT 
		,@primary_id = @LS_PrimaryId OUTPUT 
		,@overwrite = 1 

EXEC @SP_Add_RetCode = master.dbo.sp_add_log_shipping_primary_database 
		@database = N'mytestdb' 
		,@backup_directory = N'blabla' 
		,@backup_share = N'blabla' 
		,@backup_job_name = N'LSBackup_mytestdb' 
		,@backup_retention_period = 4320
		,@backup_compression = 2
		,@backup_threshold = 60 
		,@threshold_alert_enabled = 1
		,@history_retention_period = 5760 
		,@backup_job_id = @LS_BackupJobId OUTPUT 
		,@primary_id = @LS_PrimaryId OUTPUT 
		,@overwrite = 1

RegOpenKeyEx() returned error 2, 'The system cannot find the file specified.'
Сообщение 22001, уровень 1, состояние 1
сообщение: 32018, уровень: 16, состояние: 2, процедура: master.dbo.sp_add_log_shipping_primary_database, строка: 182 [строка начала пакета: 0]
Log shipping is not installed on this instance.