Page tree

For a fault-tolerant backup and restore infrastructure, you must install the SQL Safe Backup Service and SQL Safe Filter Service on the computers hosting your SQL Servers. Although you are using a clustered environment, you should not configure these services as clustered resources. Doing so would compromise their functionality in active-active clustering configurations. In the case of InstantRestore, you can perform the optional step of executing a one-time command to enable failover support for SQL Safe hydration operations. See the following topic to enable fault tolerance for IR hydration per SQL Server instance.

Install the SQL Safe backup and restore components via the SQL Safe Management Console

  1. Install the SQL Safe Management Console onto a computer using the FULL Installer. You can install on any computer, as long as it can access the servers to which you want to deploy the SQL Safe Management Console.
  2. Launch the SQL Safe Management Console.
  3. Register the clustered SQL Server instances on which you want to install the SQL Safe Backup Agent Components by right-clicking SQL Server Instances, and then selecting Register SQL Server.
  4. Right-click on the newly registered SQL Server instance in the Servers tree, and then select Properties.
  5. On the Advanced tab, update the Network Name field to include the current active node of the cluster. Click OK to save the changes. If a connection error message appears, click Yes to proceed.
  6. Go to SQL Safe Backup Agent tab in the navigation pane.
  7. Validate that the node name of the clustered SQL Server is displayed.
  8. Right-click on the node name and select Install SQLsafe Backup Agent.
  9. Click OK on the Install SQLsafe Backup Agent wizard window.
  10. Once the installation has completed, right-click on the node name and select Refresh.
  11. Once the management console refreshes, it should detect and list the remaining nodes of the cluster.
  12. Right-click the first of the remaining nodes, and then select Install SQLsafe Backup Agent. Repeat this step for each of the remaining nodes to install the SQL Safe Agent components on the remaining nodes.
  13. Verify that the Management Server column matches the correct management service. This setting is automatically set during your installation.
  14. Go to the Servers tab in the navigation pane.
  15. Right-click on the clustered SQL Server instance name and select Properties. On the Advanced tab, update the Network Name field to include the current active node of the cluster (and instanced name if it is not the default instance). Click OK to save the changes.
  16. On the Advanced tab, update the Network Name field to the clustered SQL Server instance name. Click OK to save the changes.
  17. If you want to use InstantRestore functionality, right-click the first node, and then choose Enable SQL Safe Instant Restore. Repeat this step for each of the remaining nodes. Your SQL Safe Backup Services are now installed.

Enable fault tolerance for InstantRestore Hydration per SQL Server instance (Optional)

This process is necessary only if you want fault tolerance for databases still going through the hydration process of InstantRestore. Before you begin, make sure that your SQL Safe Backup service components are already installed.

  1. Remotely log on to a node of the cluster.
  2. Open a new Command Window.
  3. For each clustered SQL Server instance hosted on that cluster server, run the following command:
    SQL SafeCmd Cluster FilterService sqlserver_name
    Where sqlserver_name is the full SQL Server Instance name of the clustered SQL Server instance.

This command creates a Generic Script Resource that controls failover for Hydration operations for that specific SQL Server. Note that this command is run only once per clustered SQL Server, not per node.



IDERA |  Products | Purchase | Support |  Community | Resources |  About Us | Legal