User profile for mechie

for your info i added a generated script to make the job. i removed the encrypted password and renamed the db to dbxx. also we have a support contract so if you need that i can provide you that information to your email. Eduard Beijnes, Holland Casino, The Netherlands -- Script generated on 27-7-2006 12:29 BEGIN TRANSACTION DECLARE @JobID BINARY(16) DECLARE @ReturnCode INT SELECT @ReturnCode = 0 IF (SELECT COUNT(*) FROM msdb.dbo.syscategories WHERE name = N'Database Maintenance') < 1 EXECUTE msdb.dbo.sp_add_category name = N'Database Maintenance' IF (SELECT COUNT(*) FROM msdb.dbo.sysjobs WHERE name = N'Full Backup DBXX') > 0 PRINT N'The job "Full Backup DBXX" already exists so will not be replaced.' ELSE BEGIN -- Add the job EXECUTE @ReturnCode = msdb.dbo.sp_add_job @job_id = @JobID OUTPUT , @job_name = N'Full Backup DBXX', @owner_login_name = N'sa', @description = N'Full Backup DBXX d.m.v. SQLBackup', @category_name = N'Database Maintenance', @... = 1, @notify_level_email = 0, @notify_level_page = 0, @notify_level_netsend = 0, @notify_level_eventlog = 2, @delete_level= 0 @ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback -- Add the job steps -- -- i removed the encryption key -- EXECUTE @ReturnCode = msdb.dbo.sp_add_jobstep @job_id = @JobID, @step_id = 1, @step_name = N'Backup', @command = N'master..sqlbackup ''-SQL "BACKUP DATABASE [DBXX] TO DISK = ''''E:\SQLServer\MSSQL\Backup\DBXX\<AUTO>'''' WITH NAME = ''''Database(DBXX)'''', DESCRIPTION = ''''Backup Database: DBXX Server: SOMESERVER'''', INIT, PASSWORD = ''''<ENCRYPTEDPASSWORD></ENCRYPTEDPASSWORD>'''', VERIFY, KEYSIZE = 256, ERASEFILES = 1h, MAILTO_ONERROR = ''''hcdba@somedomain.nl'''', COMPRESSION = 2"''', @database_name = N'master', @server = N'', @database_user_name = N'', @subsystem = N'TSQL', @cmdexec_success_code = 0, @flags = 0, @retry_attempts = 0, @retry_interval = 1, @output_file_name = N'', @on_success_step_id = 0, @on_success_action = 1, @on_fail_step_id = 0, @on_fail_action = 2 @ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback EXECUTE @ReturnCode = msdb.dbo.sp_update_job @job_id = @JobID, @start_step_id = 1 @ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback -- Add the job schedules EXECUTE @ReturnCode = msdb.dbo.sp_add_jobschedule @job_id = @JobID, name = N'Daily', @... = 1, @freq_type = 4, @active_start_date = 20060713, @active_start_time = 30000, @freq_interval = 1, @freq_subday_type = 1, @freq_subday_interval = 0, @freq_relative_interval = 0, @freq_recurrence_factor = 0, @active_end_date = 99991231, @active_end_time = 235959 @ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback -- Add the Target Servers EXECUTE @ReturnCode = msdb.dbo.sp_add_jobserver @job_id = @JobID, @server_name = N'(local)' @ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback END COMMIT TRANSACTION GOTO EndSave QuitWithRollback: @TRANCOUNT > 0) ROLLBACK TRANSACTION EndSave: / comments

for your info i added a generated script to make the job. i removed the encrypted password and renamed the db to dbxx. also we have a support contract so if you need that i can provide you that inf...

0 votes

about the job: we generated the statement using the wizard. i assume this is meant with: When using the scheduling wizard and log shipping wizard in SQL Backup version 4 and up, this is not an issue. The necessary parameters are inserted into the backup job step in the SQL Agent job. / comments

about the job: we generated the statement using the wizard. i assume this is meant with: When using the scheduling wizard and log shipping wizard in SQL Backup version 4 and up, this is not an is...

0 votes

Betelgeuse wrote: I have an Agent job that restores a backup of a production database to a development server every night. I would like to use an encrypted backup as the source, but I understand that I cannot use the encrypted form of the SQL Backup password for the restore. Are there any clever ways to get around having the unencrypted form of the password visible in msdb? hi, we have (soon had) the same problem. although it may not be an uber solution: we make a stored procedure with "with encryption" which does the actual restore. so in your job comes a call to your own custom restore stored procedure and the stored procedure contains the actual statement with password (and is made with the WITH ENCRYPTION" keywords. basically what i have works but it's not finished because it does not contain errorhandling and does not put errors properly back. due to my lack of experience it will take me some time to make it. hopefully this provides enough info for you to make such a job. eduard / comments

Betelgeuse wrote: I have an Agent job that restores a backup of a production database to a development server every night. I would like to use an encrypted backup as the source, but I understan...

0 votes

Hi, i'd like to add something: i activated the sqlbackup software while the service was running because i had a "trial expired message" (see also my other post). after activation + the service still running i still got this message. because we save the activation text i saw i already activated the software around 2 weeks ago. so that raised a question with me. stopping the service and starting it again solved the problem. so having the service running is not sufficient ... it should be restarted after activation. eduard / comments

Hi, i'd like to add something: i activated the sqlbackup software while the service was running because i had a "trial expired message" (see also my other post). after activation + the service stil...

0 votes

How can we help you today?

mechie

Comments