--primary server DECLARE @LS_BackupJobId AS uniqueidentifier DECLARE @LS_PrimaryId AS uniqueidentifier EXEC master.dbo.sp_add_log_shipping_primary_database @database = N'testbackup' ,@backup_directory = N'c:\backup' ,@backup_share = N'\\servertest\backup' ,@backup_job_name = N'LSBackup_TestBackup' ,@backup_retention_period = 1440 ,@monitor_server = N'servertest' ,@monitor_server_security_mode = 1 ,@backup_threshold = 60 ,@threshold_alert_enabled = 0 ,@history_retention_period = 1440 ,@backup_job_id = @LS_BackupJobId OUTPUT ,@primary_id = @LS_PrimaryId OUTPUT ,@overwrite = 1 ,@backup_compression = 0 GO --secondary server DECLARE @LS_Secondary__CopyJobId UniqueIdentiFier DECLARE @LS_Secondary__RestoreJobId UniqueIdentiFier DECLARE @LS_Secondary__SecondaryId UniqueIdentiFier EXEC master.dbo.sp_add_log_shipping_secondary_primary @primary_server = N'SERVERTEST' ,@primary_database = N'testbackup' ,@backup_source_directory = N'\\servertest\backup' ,@backup_destination_directory = N'c:\backup2' ,@copy_job_name = N'' ,@restore_job_name = N'' ,@file_retention_period = 1440 ,@monitor_server = N'SERVERTEST' ,@monitor_server_security_mode = 1 ,@copy_job_id = @LS_Secondary__CopyJobId OUTPUT ,@restore_job_id = @LS_Secondary__RestoreJobId OUTPUT ,@secondary_id = @LS_Secondary__SecondaryId OUTPUT GO EXEC master.dbo.sp_add_log_shipping_secondary_database @secondary_database = N'testbackup' ,@primary_server = N'SERVERTEST' ,@primary_database = N'testbackup' ,@restore_delay = 0 ,@restore_mode = 1 ,@disconnect_users = 0 ,@restore_threshold = 45 ,@threshold_alert_enabled = 0 ,@history_retention_period = 1440 GO --primary EXEC master.dbo.sp_add_log_shipping_primary_secondary @primary_database = N'testbackup' , @secondary_server = N'servertest\tweede' , @secondary_database = N'testbackup'