Upgrading the HyperBac engine components

Date: 01/02/2012
Product: SQL Storage Compress

Category: Installing and upgrading
Date: 1st February 2012

The HyperBac Engine components are used by the following products:

SQL HyperBac, SQL Virtual Restore, and SQL Storage Compress

Note: if you have more than one of these products installed, you only need to follow these steps once.

Before installing

If you are upgrading an existing version of SQL HyperBac, ensure that there are no backups currently in operation. Skip to the "Installing" section.

If you are upgrading an existing version of SQL Storage Compress or SQL Virtual Restore, and already have active compressed/virtual databases using SQL Storage Compress or SQL Virtual Restore on your server, you must do one of the following:

Take each compressed/virtual database offline, or
Stop the SQL Server instance

To take each compressed database offline:

Right-click each compressed/virtual database in SQL Server Management Studio (SSMS), and select Tasks > Take Offline. You may need to run this task twice before SSMS reports the database as being offline.

Alternatively, ensure that you are connected to the master database, then run the following T-SQL statement for each compressed/virtual database:

ALTER DATABASE <database name> SET OFFLINE

You may need to run this statement twice before SQL Server reports the database as being offline.

To stop the SQL Server instance:

Right-click on the instance in SSMS.
Click Pause.
Click Stop.

Alternatively, stop the service in the Windows services list.

Installing

Install the HyperBac engine components

for 64-bit machines, run HyperBac_Installer_x64.exe
for 32 bit machines, run HyperBac_Installer_x86.exe

After installing

Re-boot your machine. Until the machine has been rebooted, the latest version of the HyperBac engine components will not be installed and you will be unable to bring your compressed databases back online.
For SQL Storage Compress and SQL Virtual Restore: Bring each compressed/virtual database back online. You can do this in two ways:

In SSMS, use the Bring online task, or
Ensure you are connected to the master database, then run the following T-SQL statement for each compressed/virtual database:

ALTER DATABASE <database name> SET ONLINE

Note: For engine component upgrades only, you will not need to enter a new serial key.