First, consider the T-SQL command that was used to back up the "AdventureWorks" database using SQL HyperBac encryption:

BACKUP DATABASE [AdventureWorks] TO DISK = 'D:\Backups\AdventureWorks_backup.hbe'

Simply run a RESTORE DATABASE command as you usually would:

RESTORE DATABASE [AdventureWorks] FROM DISK = 'D:\Backups\AdventureWorks_backup.hbe'

That's all you need to do. SQL HyperBac will automatically decrypt the backup data during the restore operation.

Note that the key file that was used to encrypt the backup data must be available to SQL HyperBac on the system you are restoring to. By default, SQL HyperBac looks for key files in "C:\Program Files\Red Gate\HyperBac\keys".

Read Managing key files for encrypted backups for important information about managing and backing up key files.