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