This page applies to:
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 page describes:
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.
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.
Open the Registry Editor (regedit.exe) and navigate to the SQL Backup branch in the registry editor:
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
For SQL Backup 6.3 and earlier on 64-bit servers, the branch is in
- 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 subkeys from the SQL Backup branch:
When you have performed these steps on the SQL Server instances as required, you can start the manual installation.
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.
For more information about using SQBServerSetup.exe see Installing the server components on a SQL Server cluster.
- On step 2 of the wizard, the clustered SQL Server instances will be shown in the list of available instances in the wizard. Select a clustered instance and click Next.
- On step 3, ensure you clear the option to Install SQL Backup on all cluster nodes.
- On step 4, specify a domain account with sufficient privileges to run as a service, including the Log on as a service permission, for the SQL Backup Agent service to run as.
- On step 5, choose the authentication mode for the SQL Backup Agent service to connect to the SQL Server cluster. The account must be a member of the sysadmin fixed server role.
- On step 6, specify a location for the SQL Backup data store which is a shared drive, accessible by all nodes in the cluster. The location must be specified as a local path (for example, E:\SQLBackupData\(local)\), and not as a UNC path (for example, \\server\share\(local)\).
- On step 7, the location for the SQL Backup server component files must be a local drive.
- Use the Services application to stop the SQL Backup Agent service if it is running. If you are stopping this service on a non-default instance, the service name will be in the form: SQL Backup Agent-<instance>.
- Open the Registry Editor (regedit.exe) and navigate to the SQL Backup branch in the registry editor:
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 following registry entries in the SQL Backup branch:
- In BackupSettingsGlobal\<instance>, create a string value called DataPath and set the value to a folder on the shared storage.
- In InstalledInstances\<instance>, create a dword value called IsCluster and set the value to 1.
When you have completed these steps on all the SQL Server nodes in the cluster, create the clustered resource using the Cluster Administrator tool:
- Right-click on the SQL Server group, click New, and then click Resource.
On the New Resource page, enter the following details:
|Name:||SQL Backup Agent - <instance>|
|Resource type:||Generic Service|
|Group:||The group to which the SQL Server instance is registered.|
- On the Possible Owners page, ensure that the nodes listed match those that the SQL Server instance can run on.
- On the Dependencies page, you are recommended to add the SQL Server instance and the physical disk.
- On the Generic Service Parameters page, ensure the Service name is listed as SQLBackupAgent for the default instance, or SQLBackupAgent_<instance> for a named instance.
For a named SQL Server instance, enter the Start parameters as
- On the Registry Replication page, 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.
- Open the SQL Backup graphical user interface and use the 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 6 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 stored has been correctly replicated, this will list both backups.
- If required, fail over to the first node.