Page History

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

The following instructions help you to configure the SQL Safe Backup services in its own cluster. This option requires an Make sure you have an available disk on in the cluster to store the temporary files used by the SQLSafe SQL Safe Backup services.

Create a Role

1. Log onto the active cluster node using an Administrator Account.

2. Launch the Microsoft Failover Cluster Manager.

3. Right-click on Roles and select Create Empty Role.
4. Right-click on the newly created role and select Properties.

5. Rename the role to a unique name (e.g. SQLSafeServices), then click OK.

6. Right-click on the role and select Add Resource > Client Access Point.
   On the Client Access Point screen, enter a unique Network Name (e.g. SQLSafeCluster) and an available IP Address that has been reserved for the clustered resource, then click Next.
   On the the  Confirmation screen, click Next.
   On the the  Summary screen, click Finish.
7. Right-click on the role and select Add Resource > Generic ServiceStorage.

8. On the Select Service screen, locate and select the SQL Safe Collection Service. Click Next to proceed.

9. On the Confirmation screen, click Next.

10. Select an available disk, then click OK. 

Add a Shared Path

1. Open File Explorer and navigate to the drive that was added as the storage resource.
2. Create a folder for the SQL Safe Backup services (e.g. H:\Idera\SQLsafe\).
3. Launch Registry Editor and navigate to HKLM\SOFTWARE\Idera\SQLsafe.
4. Create a new string value named Shared Path and supply the path to the folder (e.g. H:\Idera\SQLsafe\).

Create a Generic Service Resource

1. Create a Generic Service resource for each of the SQL Safe Backup services (SQL Safe Backup Service, SQL Safe Collection Service, SQL Safe Filter Service, SQL Safe Management Service, SQL Safe OLR Service, and SQL Safe Rest Service).On the Summary screen, click Finish. 
   1. Right-click on the role and select Add Resource > Generic Service.
      On the Select Service screen, locate and select the SQL Safe
   Management
   1. Backup Service. Click Next to proceed.
      On the Confirmation screen, click Next. 
      On the Summary screen, click Finish. 
   2. Right-click on the role and select Add Resource > Generic Service.
      On the Select Service screen, locate and select the SQL Safe
   Rest
   1. Collection Service. Click Next to proceed.
      On the Confirmation screen, click Next. 
      On the Summary screen, click Finish. 
   2. Right-click on the
   newly added Role for the SQL Safe Collection Service and select Properties.

2. On the Properties window, go to the Dependencies tab.

3. Add the following dependencies:

   1. Name of the clustered role.
   2. IP address.

4. Click Apply.

5. Go to the General tab.

6. Enable the Use Network Name for computer name checkbox, then click OK.

7. Right-click on the newly added Role for the SQL Safe Management Service and select Properties.

8. On the Properties window, go to the Dependencies tab.

9. Add the following dependencies:

   1. Name of the clustered role.
   2. IP address.

10. Click Apply.

11. Go to the General tab.

12. Enable the Use Network Name for computer name checkbox, then click Apply.

13. Go to the Registry Replication tab.

14. Click the Add button and enter SOFTWARE\Idera\SQLsafe\Management Service into the Root Registry Key field, then click OK.

    Warning
    There is a bug in Windows 2012 where the Registry Replication tab is not available. If the tab is unavailable, use the Add-ClusterCheckpoint PowerShell cmdlet to add the necessary setting. EXAMPLE: Add-ClusterCheckpoint -ResourceName "SQLsafe Management Service" -RegistryCheckpoint "SOFTWARE\Idera\SQLsafe\Management Service" -Cluster "[ClusterName]"

15. Right-click on the newly added Role for the SQL Safe Rest Service and select Properties.

16. On the Properties window, go to the Dependencies tab.

17. Add the following dependencies:

    1. Name of the clustered role.
    2. IP address.

18. 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\SQLSafeRestService into the Root Registry Key field, then click OK.

    Warning
    There is a bug in Windows 2012 where the Registry Replication tab is not available. If the tab is unavailable, use the Add-ClusterCheckpoint PowerShell cmdlet to add the necessary setting. EXAMPLE: Add-ClusterCheckpoint -ResourceName "SQLsafeRestService" -RegistryCheckpoint "SOFTWARE\Idera\SQLSafeRestService" -Cluster "[ClusterName]"

19. Right-click on the Role and select Start Role.

20. Launch the SQL Safe Management Console (Start > All Programs > IDERA > SQL Safe Management Console).

21. Go to Tools > Repository and Management Service Settings. 

22. Next to the Computer field, click the Change button.

23. On the window that appears, enter the cluster name that SQL Safe Management Service is associated to, then click OK.

24. Click OK on the Repository and Management Service Settings window.

...

1. 1. role and select Add Resource > Generic Service.
      On the Select Service screen, locate and select the SQL Safe Filter Service. Click Next to proceed.
      On the Confirmation screen, click Next. 
      On the Summary screen, click Finish. 
   2. Right-click on the role

2. Log onto the active cluster node using an Administrator Account.

3. Launch the Microsoft Failover Cluster Manager.

4. Right-click on the role created for the clustered instance
   1. and select Add Resource > Generic Service.
      On the Select Service screen, locate and select the SQL Safe
   Collection
   1. Management Service. Click Next to proceed.
      On the Confirmation screen, click Next. 
      On the Summary screen, click Finish.
   2. Right-click on the role
   created for the clustered instance
   1. and select Add Resource > Generic Service.
      On the Select Service screen, locate and select the SQL Safe
   Management
   1. OLR Service. Click Next to proceed.
      On the Confirmation screen, click Next. 
      On the Summary screen, click Finish.
   2. Right-click on the role
   created for the clustered instance
   1. and select Add Resource > Generic Service.
      On the Select Service screen, locate and select the SQL Safe Rest Service. Click Next to proceed.
      On the Confirmation screen, click Next. 
      On the Summary screen, click Finish.

5. Right-click on the newly added Role for the SQL Safe Collection Service and select Properties.

6. On the Properties window, go to the Dependencies tab.

7. Add the following dependencies:

   1. Name of the clustered role. 

   2. IP address. 

8. Click Apply. 

9. Go to the General tab.

10. Enable the Use Network Name for computer name checkbox, then click OKConfigure the properties for each of the newly created generic service resources.
    
    1. Right-click on the newly
    added Role for the SQL Safe Management Service
    1. generic service resource and select Properties.
       
    On 
    1. On the Properties window, go to the Dependencies tab.
       Add the following dependencies:
       1. Name of the clustered role.
        
       IP address
       1. Storage resource.
        
    Click
    1. Click Apply.
     
    2. Go to
    the
    1. the General
    tab
    1.  tab. 
    2. Enable the Use Network Name for computer name checkbox, then click Apply.
     
    2. Go to the Registry Replication tab. Click the Add button and

    enter

    1. enter SOFTWARE\Idera\SQLsafe\

    Management Service into

    1.  into the Root Registry Key field, then click

    Ok

    1. OK.

    warning

    1. Note

       There is a bug in Windows 2012 where the Registry Replication tab is not available. If the tab is unavailable, use the  Newtablink alias Add-ClusterCheckpoint url https://docs.microsoft.com/en-us/powershell/module/failoverclusters/add-clustercheckpoint?view=win10-ps  PowerShell cmdlet to add the necessary setting. EXAMPLE: Add-ClusterCheckpoint -ResourceName "SQLsafe Management Service" -RegistryCheckpoint "SOFTWARE\Idera\SQLSafe\Management Service" -Cluster "[ClusterName]"

    2. Repeat the steps above for each generic service resource.
11. Right-click on the newly added Role for the SQL Safe Rest Service and select Properties Start Role.  

12. On the Properties window, go to the Dependencies tab. 

13. Add the following dependencies:

    1. Name of the clustered role.

    2. IP address. 

14. Click Apply.

15. Go to the General tab.

16. Enable the Use Network Name for computer name checkbox, then click Apply.

17. Go to the Registry Replication tab. Click the Add button and enter SOFTWARE\Idera\SQLSafeRestService into the Root Registry Key field, then click OK.

    Warning
    There is a bug in Windows 2012 where the Registry Replication tab is not available. If the tab is unavailable, use the Add-ClusterCheckpoint PowerShell cmdlet to add the necessary setting. EXAMPLE: Add-ClusterCheckpoint -ResourceName "SQLsafeRestService" -RegistryCheckpoint "SOFTWARE\Idera\SQLSafeRestService" -Cluster "[ClusterName]"

Bring each of the newly created roles for the SQL Safe services online (in any order).

Reconfigure the SQL Safe Management Console

1. Launch the SQL Safe Management Console (Start > All Programs > IDERA > SQL Safe Management Console).
2. Go to Tools > Repository and Management Service Settings. 
3. Next to the Computer field, click the Change button.

4. On the window that appears, enter the cluster name that SQL Safe Management Service is associated to, then click OK. .

5. Update the SQL Server and Database field if necessary.

6. Click OK on the Repository and Management Service Settings window.

SQL Safe   is a high-performance backup and recovery solution for your SQL Servers. Learn more > >

...