Page History

...

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 clicking SQL Server Instances, and then selecting Register 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 Agents 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.

...

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.