Creating a new role for the SQL Safe Backup services ensures the high availability of the services during a failover. This set of instructions helps you to configure SQL Safe Backup services in its own cluster. This option requires an available disk on the cluster to store the temporary files used by the SQL Safe Backup services.
Log onto the active cluster node using an Administrator Account.
Launch the Microsoft Failover Cluster Manager.
Rename the role to a unique name (e.g. SQLSafeServices), then click OK.
Click Apply.
Go to the General tab.
Enable the Use Network Name for computer name checkbox, then click Apply.
Go to the Registry Replication tab. Click the Add button and enter SOFTWARE\Idera\SQLsafe\Management Service into the Root Registry Key field, then click OK.
There is a bug in Windows 2012 where the Registry Replication tab is not available. If the tab is unavailable, use the PowerShell cmdlet to add the necessary setting. EXAMPLE: Add-ClusterCheckpoint -ResourceName "SQLsafe Management Service" -RegistryCheckpoint "SOFTWARE\Idera\SQLSafe\Management Service" -Cluster "[ClusterName]" |
Right-click on the newly added Role for the SQL Safe Rest Service and select Properties.
On the Properties window, go to the Dependencies tab.
Add the following dependencies:
Click Apply.
Go to the General tab.
Enable the Use Network Name for computer name checkbox, then click Apply.
Go to the Registry Replicationtab. Click the Addbutton and enterSOFTWARE\Idera\SQLSafeRestServiceinto the Root Registry Key field, then click OK.
There is a bug in Windows 2012 where the Registry Replication tab is not available. If the tab is unavailable, use the PowerShell cmdlet to add the necessary setting. EXAMPLE: Add-ClusterCheckpoint -ResourceName "SQLsafeRestService" -RegistryCheckpoint "SOFTWARE\Idera\SQLSafeRestService" -Cluster "[ClusterName]" |
Right-click on the Role and select Start Role.
On the window that appears, enter the cluster name that SQL Safe Management Service is associated to, then click OK.
Click OK on the Repository and Management Service Settings window.
| | | | | | | |