The procedure encrypts a password into a value for @jobp, that is suitable for xp_backup_database and xp_backup_log procedures as an encrypted key.
EXEC master.dbo.xp_encrypt_backup_key
@key ='Mypassword'
The Results tab displays the encrypted key.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center