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

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

Simply run a RESTORE DATABASE command as you usually would:

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

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

Exactly the same applies when restoring backup files that use SQL HyperBac fast compression or ZIP-compatible compression. Just use one of the following RESTORE DATABASE commands, and SQL HyperBac will automatically decompress the backup data during the restore operation:

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

or,

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

or,

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

Whether you run T-SQL statements from SQL Server Management Studio (either by explicitly typing the statement, or using the GUI options), using SQLCMD, or with any other tool, SQL HyperBac will automatically intercept the backup data, and decompress it.