What are the challenges you face when working across database platforms? Take the survey

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',
@Directory = 'R:\Backups',
@BackupType = 'FULL',
@Verify = 'Y',
@Compress = 'Y',
@BackupSoftware = 'SQLBACKUP',
@CheckSum = 'Y',
@Encrypt = 'Y',
@EncryptionKey = 'ola5dKAWc3PuvU5k',
@LogToTable = 'Y'

Any suggestions would be greatly appreciated.

Thank you


Sign In or Register to comment.