SQLsafe is comprised of multiple application components, each providing specific functionality in different areas of the product. These different areas of functionality have specific concerns when deploying in a clustered environment, as redundancy and high availability are an issue. The following table includes the applications and services that SQLsafe is comprised of, with a summary of the requirements of each to be fully fault tolerant using the Microsoft Windows Clustering technology. SQLsafe components can work in either active-passive or active-active cluster configurations.

ComponentClustering Configuration Considerations

SQLsafe Management Console

None.

SQLsafe Command Line

None.

SQLsafe Management Service

This component is responsible for managing operational and policy status and alerting for your entire SQLsafe deployment. If you require these SQLsafe functions to be fault tolerant, configure this component as a Generic Service Resource on a clustered server. You need to deploy this component only once onto a single cluster, not on each server you are backing up. For more information about installing the SQLsafe Management Service on a Windows cluster, see Installing management components in a clustered environment.

SQLsafe Repository Database

This component is a SQL Server database used to stored operational history and policy configuration information. The SQLsafe Repository Database is used by the Management Console to display operational history and by the Management Service to process and send alerts. For this component to be fault-tolerant, simply host the database on a clustered SQL Server.

SQLsafe Backup Service

This component is responsible for executing backup and restore operations on nodes hosting any clustered SQL Servers. You need to install this service only on each node of the cluster. No failover or cluster resource configuration is necessary. You can deploy the agent from the Management Console or the product installer.

SQLsafe Filter ServiceThis component is responsible for performing instant restore operations on nodes hosting any clustered SQL Servers. If you require that SQLsafe Instant Restore functionality be fault tolerant, configure this component via the SQLsafe Command Line. You should not configure this service as a clustered resource. Instead, a failover mechanism is activated via a Generic Script Resource, and is automatically configured for you using a SQLsafe command. For more information about installing the SQLsafe Filter Service on a Windows cluster, see Installing backup/restore components in a clustered environment.
  • No labels