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

Configuring Encryption using the Ola Hallengren Backup Solution

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',
@... = '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
ClarkChris
0

Comments

3 comments

Sort by
  • 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?
    BrainDonor
    0
  • 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
    0
  • 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
    ClarkChris
    0

Add comment

Please sign in to leave a comment.