Page History
Registering the SQL Safe Backup services with Microsoft Failover Cluster Manager allows the Microsoft Cluster Service to manage the services in failover situations. The following configuration ensures the high availability of the services during a failover.
There are two ways to register the SQL Safe Backup services as a clustered resource:
- Creating a new role for the SQL Safe Backup services.
- Adding the SQL Safe Backup services to an existing role.
The following instructions guide you through the installation of SQL Safe Management components in a clustered environment.
Tip |
---|
Install the IDERA Dashboard on another Server because it is not supported in a cluster environment. |
- Log on with an administrator account to the cluster environment where you want to install SQL Safe.
Run SQLSafeBackupInstall-{32|64}bit-version.exe in the root of the installation kit.
Info Run the installer on all the cluster nodes where you want to host your SQL Safe Management Service, whether active or inactive.
- In the installation wizard, select Custom, click Next.
- Select to install SQL Safe Backup only.
- Review the license agreement. To accept this license agreement, select the I accept the terms and conditions checkbox. Click Next.
- Determine the registration of SQL Safe with an existing IDERA Dashboard. By default, the option Yes is selected. As your IDERA Dashboard is located on a remote server, then specify the Server Name that hosts the SQL Safe Management Service and the Port number of this server. Type administrator credentials to access this Dashboard and click Next.
- Specify the Destination Folder where you want to install the SQL Safe Backup application. Click Next.
- Specify the Cluster SQL Server Instance, Database Name, and Authentication you want to use for the SQL Safe Backup Repository.
By default, the Windows Authentication is selected. If you want to use the Microsoft SQL Server Authentication, select this option and specify the login name and password for this account, and click save.
Before you continue, you can Test Connections to make sure the SQL Server instance is connected. Then, click Next. - Specify the Service Accounts under which the SQL Safe Backup and IDERA Dashboard will run.
- Specify the account to be used by the SQL Safe Backup Management Service to connect to the SQL Safe Backup Repository Database.
By default, the Windows account specified on the previous step is selected. If you want to use the Microsoft SQL Server Authentication, select this option and specify the respective SQL Sever login credentials, and click Next. - Once SQL Safe is ready to install, review the settings you selected and click Install. If you want to edit your settings, select back and make your changes.
- When the installation completes, you can either:
- Go to the Start Menu: select IDERA - SQL Safe Management Console.
- Configure the Firewall.
- Launch the SQL Safe Management Console.
- Click Finish.
Upgrades automatically choose the correct components for you. To make the repository database clustered, simply specify a Clustered SQL Server to host the Repository database.
Before you begin, open the Windows Services application (services.msc) and find the SQL Safe Management Service. Make sure that the Startup Type is set to Manual and that the service status is Stopped in all but the active node. If you are upgrading your installation, there are no more requirements. If you are installing a new deployment, you must also configure the Management Service as a Generic Service Resource. Select the appropriate task below to perform this action.
Configuring the SQL Safe Management Service as a Generic Service Resource using Windows Server 2008/ Windows Server 2008 R2 and later
...
- Open the Windows Failover Cluster Management application named cluadmin.msc.
- Right-click Services and Applications, and then select Configure a Service or Application.
- On the Select Service or Application window, click Generic Service, and then click Next.
- On the Select Service window, click SQL Safe Management Service, and then click Next.
- On the Client Access Point window, type or select the IP address and network name that you want to use to access the SQL Safe Management Service, and then click Next.
- On the Select Storage window, click Next.
- On the Replicate Registry Settings window, click Add.
- In the root registry field, type the following text:
Software\IDERA\SQL Safe\Management Service
- Click OK.
- Click Next.
- On the Confirmation window, click Next. The wizard configures the service as displayed on the Configure High Availability window, and then displays the Summary window.
- On the Summary window, click Finish. Your SQL Safe Management Service is now configured for cluster failover.
Use the following steps if you do have an existing application or service, already configured with the IP address and network name that you want to also use for the SQL Safe Management Service.
- Open the Windows Failover Cluster Management application named cluadmin.msc.
- Right-click the application, and then select Add a resource > 4 - Generic Service.
- On the Select Service window, wait while the services populate the fields with a list of services installed on this computer.
- Click SQL Safe Management Service, and then click Next.
- On the Confirmation window, click Next. The wizard configures the service as displayed on the Configure Generic Service window, and then displays the Summary window.
- On the Summary window, click Finish.
- Right-click your new Generic Service resource, and then select Properties. SQL Safe now displays the SQL Safe Management Service Properties window which contains many tabs.
- On the General tab, check the Use Network Name for Computer Name check box.
- On the Dependencies tab, add the Network Name and IP Address resources belonging to this application.
- On the Registry Replication tab, click Add.
- In the root registry field, type the following text:
Software\IDERA\SQL Safe\Management Service
- ClickOK.
- On the SQL Safe Management Service Properties window, click OK.
- Right-click your new Generic Service resource, and then select Bring this resource online. Your SQL Safe Management Service is now configured for cluster failover.
...
SQL Safe is a high-performance backup and recovery solution for your SQL Servers. Learn more > >
...