Configuring Encryption using the Ola Hallengren Backup Solution

ClarkChris

I am unable to restore the full backups (the key doesn't decrypt the full backup when using Redgate SQL Backup).  Here is the example of the backup script:

EXECUTE [dbo].[DatabaseBackup]

@Databases = 'USER_DATABASES',

@Directory = 'R:\Backups',

@BackupType = 'FULL',

@Verify = 'Y',

@Compress = 'Y',

@CleanupTime = 48,

@BackupSoftware = 'SQLBACKUP',

@CheckSum = 'Y',

@CompressionLevel = 3,

@Threads = 3,

@Encrypt = 'Y',

@EncryptionAlgorithm = 'AES_256',

@EncryptionKey = 'ola5dKAWc3PuvU5k',

@LogToTable = 'Y'

Any suggestions would be greatly appreciated.

Thank you

BrainDonor

Could you clarify this please? Are you using Ola's backup process to create the backup but attempting the restore via the Redgate Backup Pro ? If you restore via T-SQL, does it work?

ClarkChris

Yes, I am creating the full backups using the Ola Hallengren solution, and then attempting to restore using Redgate SQL Backup.  I have not been able to restore with T-SQL either. The password doesn't decrypt.

ClarkChris

I was using the obfuscated password in my @EncryptionKey = 'ola5dKAWc3PuvU5k' and this wouldn't decrypt.  When I use the plain text @EncrytionKey = 'TestPassword' then it works fine.  Thank you