Manually installing SQL Backup server components on clusters (Windows Server 2008)

This article applies to:

Clusters running on Windows Server 2008 only.
If your cluster is running on Windows server 2003, refer to Manually installing SQL Backup server components on clusters (Windows 2003) instead.
SQL Backup versions 5, 6 and 7

You can install SQL Backup on a Microsoft Cluster Service without using the clustering functionality of the SQL Backup installer. For example, you may want to do this if you have already experienced problems using the installer on a cluster.

This article describes:

the licensing requirements
how to clean up following a previous SQL Backup installation
how to manually install SQL Backup as a clustered resource
how you can test the installation

Licensing

You must have a SQL Backup Pro license for each server on which you want to install the SQL Backup server components. This means that each node (physical computer) must have its own license.

For example, a two node active-active cluster must have two licenses, and a two node active-passive cluster must also have two licenses.

A SQL Backup Pro license is always required because clustered SQL Server instances use a distinct IP address which is considered 'remote' when managed from the SQL Backup graphical user interface.

Cleaning up an existing installation

If you have already attempted to install SQL Backup on the cluster but the installation did not complete successfully, you must 'clean up' the SQL Server instances.

To do this, perform the following steps on each of the SQL Server instances on which the installation failed:

Uninstall the server components using the Add or Remove Programs dialog box.
You will be asked whether you want to remove the SQL Backup file containing the history of the backup and restore activity. If you want to save or archive the data store, ensure you click No on this dialog box.
Go to the SQL Backup branch in the registry editor:
To open the registry editor, on the Start menu, click Run, and then type regedit.

For all versions of SQL Backup on 32-bit servers, and for SQL Backup 6.4 and later on 64-bit servers, the branch is in:

HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate

For SQL Backup 6.3 and earlier on 64-bit servers, the branch is in:

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Red Gate
In the next step you will delete the contents of the SQL Backup branch, so if you want to copy your settings back later you should export the branch; select the SQL Backup branch, and on the File menu, click Export.
Delete the following settings from the SQL Backup branch:
BackupSettings\<instance>

BackupSettingsGlobal\<instance>

InstalledInstances\<instance>

where <instance> is the name of the SQL Server instance.

When you have performed these steps on the SQL Server instances as required, you can start the manual installation.

Installing manually

Important: Although they are similar, this manual installation process (for SQL Backup versions 5, 6 and 7) has critical differences from version 4. If you do not observe these differences, the installation will not be fully cluster-aware.

To install the SQL Backup server components, perform the following steps on each SQL Server instance in the cluster.

To start the SQL Backup (server components) Setup Wizard, run SQBServerSetup.exe on the cluster node.
See Installing on a SQL Server cluster for more details.

The clustered SQL Server instances will be shown in the list of available instances in the wizard. When you select a clustered instance and click Next, the wizard displays the option to Install SQL Backup on all cluster nodes. Ensure you clear the check box.

Note:
- The account for the SQL Backup Agent Service application must be a domain account, and it must have sufficient privileges to run as a service, including the Log on as a service permission.
- The location for the SQL Backup data store must be a shared drive, accessible by all nodes in the cluster. This must be specified as a local path (for example, E:\SQLBackupData\(local)\), and not as a UNC path (for example, \\server\share\(local)\).
- The location for the SQL Backup server component files must be a local drive.
When the installation finishes, a warning will be displayed to inform you that the service is not running. This is expected when manually installing a cluster.
Stop the SQL Backup Agent Service application if it is running, using the Services application.
Note: If you are stopping this service on a non-default instance, the service name will be in the form: SQL Backup Agent-<instance>.
Go to the SQL Backup branch of the registry as follows:
To open the registry editor, on the Start menu, click Run, and then type regedit.

For all versions of SQL Backup on 32-bit servers, and for SQL Backup 6.4 and later on 64-bit servers, the branch is in:

HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate

For SQL Backup 6.3 and earlier on 64-bit servers, the branch is in:

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Red Gate
Create or modify the registry keys in the SQL Backup branch as follows:
In BackupSettingsGlobal\<instance>:

Key

Type

Value

DataPath

string

A folder on the shared storage, for example:

S:\Program Files\Red Gate\SQL Backup\Data\<instance>

In InstalledInstances\<instance>:

Key

Type

Value

IsCluster

dword

1

where <instance> is the name of the SQL Server instance.

When you have completed these steps on all the SQL Server nodes in the cluster, create the clustered resource using the Failover Cluster Management tool:

In the left-hand pane, expand the cluster, then expand Services and Applications.
Right-click on the SQL Server group, click Add a Resource, and then click Generic Service.
The New Resource Wizard is displayed.
Select SQL Backup Agent-<instance> from the list then click Next.
The list is not ordered alphabetically, so you may have to scroll through the entire list to find the SQL Backup Agent-<instance> resource.

Note: If the SQL Backup Agent service is already clustered, it will not be available in the list.
Click Next on the Confirmation page of the wizard.
Click Finish on the Summary page of the wizard.
The new resource has now been created (offline) and is listed under Other Resources.
Under Other Resources select SQL Backup Agent-<instance>, then, on the Actions list click Properties for this resource.
The SQL Backup Agent-<instance> Properties dialog is displayed.
On the General tab, enter the Startup parameters as -i <instance>
On the Dependencies tab, we recommend that you add the SQL Server instance and the physical disk.
On the Policies tab, select the If resource fails, attempt restart on current node option.
On the Advanced Policies tab, ensure that all the nodes in the Possible Owners list are selected.
On the Registry Replication tab, add the following registry keys (do not include the HKEY_LOCAL_MACHINE prefix):
For all versions of SQL Backup on 32-bit servers, and for SQL Backup 6.4 and later on 64-bit servers:

SOFTWARE\Red Gate\SQL Backup\BackupSettings\<instance>

SOFTWARE\Red Gate\SQL Backup\BackupSettingsGlobal\<instance>

For SQL Backup 6.3 and earlier on 64-bit servers:

SOFTWARE\Wow6432Node\Red Gate\SQL Backup\BackupSettings\<instance

SOFTWARE\Wow6432Node\Red Gate\SQL Backup\BackupSettingsGlobal\<instance>
Bring the Clustered Resource online.

You have now completed the manual installation.

Testing the installation

To ensure that SQL Backup is clustered correctly, you can perform the following test. This procedure includes at least one failover of the resource group.

Use the SQL Backup graphical user interface Back Up wizard to perform a backup, ensuring that you save the backup settings to a template by selecting the Save as template check box on Step 5 of the wizard.
The template will be included in the registry under BackupSettings\<instance>
In Microsoft SQL Server Management Studio, list the backup that you have just performed by typing the following query:
master..sqbdata 'SELECT * FROM backuphistory'
Fail over to the second node.
Use the Back Up wizard to perform a second backup using the template you created.
If the registry keys have been correctly replicated, the template will be displayed in the list of templates in Step 1 of the wizard.
In SQL Server Management Studio, list the backups you have performed by typing the following query:
master..sqbdata 'SELECT * FROM backuphistory'

If the data store has been correctly replicated, this will list both backups.
If required, fail over to the first node.