How can we help you today? How can we help you today?

Is there a way to hide the encryption password on the sql backup job?

We created backup jobs for the database and transaction logs and enabled the encryption with a password. Unfortunately when we view the job under the SQLServerAgent/Jobs the encryption password is set in plain text in the job for anybody to view. Is there a way to hide the password?
yoyodynedata
0

Comments

3 comments

Sort by
  • crimdon
    I use the GUI to create jobs with a password and it always put this in the options:

    PASSWORD = ''<OBFUSCATEDPASSWORD>xxx</OBFUSCATEDPASSWORD>'
    crimdon
    0
  • yoyodynedata
    Actually I do see that in most of the backup jobs. However, we have a Log Shipping job that I created using the SQLBackup GUI and the first step that backs up the transaction log has the Obfuscated Password but the Restore step has the password embedded in it in plain text.
    yoyodynedata
    0
  • crimdon
    I see that too. Maybe try adding the Obfuscated Password from the backup job?
    crimdon
    0

Add comment

Please sign in to leave a comment.