Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Adding the SQL Safe Backup services to an existing role helps with the high availability of the services in failover situations.

The following set of instructions helps help you to add the SQL Safe Backup services to an existing role.

Add a Shared Path

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

  2. Open File Explorer and navigate a drive that is a shared storage resource for the cluster.
  3. Create a folder for the SQL Safe Backup services (e.g. H:\Idera\SQLsafe\).
  4. Launch Registry Editor and navigate to HKLM\SOFTWARE\Idera\SQLsafe.
  5. 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. Log onto the active cluster node using an Administrator Account.
  2. Launch the Microsoft Failover Cluster Manager.
  3. 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).
    1. Right-click on the role created for the clustered instance and select Add Resource > Generic Service. 
      On the Select Service screen, locate and select the SQL Safe
    Collection
    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 created for the clustered instance and select Add Resource > Generic Service. 
      On the Select Service screen, locate and select the SQL Safe
    Management
    1. Collection 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 and select Add Resource > Generic Service. 
      On the Select Service screen, locate and select the SQL Safe
    Rest
    1. Filter Service. Click Next to proceed.
     

    1. On the Confirmation screen, click Next.
      On the Summary screen, click Finish .
    2. Right-click on the
    newly added Role
    1. role created for the
    SQL Safe Collection Service
    1. clustered instance and select
    Properties
    1. Add Resource > Generic Service. 
      On the
    Properties window, go to the Dependencies tab.
    Add the following dependencies:
    1. Name of the clustered role. 
    2. IP address. 
    Click Apply
    Go to the General tab. 
    Enable the Use Network Name for computer name checkbox, then click OK
    1. Select Service screen, locate and select the SQL Safe 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 and select Add Resource > Generic Service. 
      On the Select Service screen, locate and select the SQL Safe OLR Service. Click Next to proceed.
      On the Confirmation screen, click Next.
      On the Summary screen, click Finish .
    3. Right-click on the
    newly added Role
    1. role created for the
    SQL Safe Management Service
    1. clustered instance and select
    Properties
    1. 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 .
  4. Configure the properties for each of the newly created generic service resources.
    On  the Properties window, go to the Dependencies tab.
    Add the following dependencies:
    1. Name of the clustered role. 
    2. IP address. 

    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.

    Warning

    There is a bug in Windows 2012 where the Registry Replication tab is not available. If the tab is unavailable, use the 

    Newtablink
    aliasAdd-ClusterCheckpoint
    urlhttps://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]"

    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. 
    1. Right-click on the newly generic service resource and select Properties.
      On the Properties window, go to the Dependencies tab.

    1. 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.
    3. Go to

    the
    1. the Registry

    Replication tab
    1. Replication tab. Click

    the Add
    1. the Add button and

    enter SOFTWARE
    1. enter SOFTWARE\Idera\

    SQLSafeRestService into
    1. SQLsafe\ into the Root Registry Key field, then

    click
    1. click 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
      aliasAdd-ClusterCheckpoint
      urlhttps://docs.microsoft.com/en-us/powershell/module/failoverclusters/add-clustercheckpoint?view=win10-ps
       PowerShell cmdlet to add the necessary setting.

      EXAMPLE:

    Add
    1. Add-ClusterCheckpoint -ResourceName "

    SQLsafeRestService
    1. SQLsafe Management Service" -RegistryCheckpoint "SOFTWARE\Idera\

    SQLSafeRestService
    1. SQLSafe\Management Service" -Cluster "[ClusterName]"

    2. Repeat the steps above for each generic service resource.

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

Reconfigure the SQL Safe Management Console

  1. Launch the Launch the SQL Safe Management Console (Start > All Programs > IDERA > SQL Safe Management Console).
  2. Go toto Tools >  > Repository and Management Service Settings. 
  3. Next to the the Computer field field, click thethe Change button 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.



Scroll pdf ignore
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
 | 
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
 
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
 | 
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
 | 
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
 
|
 
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
 | 
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
 
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse