Where are the encrypted passwords stored when using xp_encrypt_backup_key and xp_encrypt_restore_key to create the information needed for the @jobp parameter? Do you use the same @key value for both to properly restore the database?
WORKAROUND:
xp_encrypt_backup_key encrypts the user password and should be provided to a backup job via @jobp (Job Password) parameter.
Example:
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy