This article is for Amanda Enterprise (AE)
Amanda Enterprise (hereafter called AE), working with the Zmanda Windows Client (hereafter called ZWC), can be used to take backups of an SQL Server cluster. However, because Amanda Enterprise is not fully “cluster-aware”, there are certain restrictions to be aware of and requirements that must be met. The ZWC shares code with our parent company Carbonite’s full featured Windows Server backup program Carbonite Server Backup. For this reason, “ZWC Service” or “ZWC-Database” are sometimes listed as “Carbonite Server Backup Controller” and “Carbonite Server Database” respectively. Treat these Carbonite services exactly as you would the ZWC services in these instructions.
The ZWC must be installed on all nodes in the cluster.
Moving SQL Instance Between Cluster Nodes After Initial Setup
If you move SQL instance from the primary cluster node to another node after initial setup, you must also adjust your AE and ZWC configuration, unless you are planning to move resource back before scheduled backup takes place.
Differential Backups in a SQL Server Cluster
Because AE is not fully cluster-aware, you must take great care when using Differential backups in a clustered environment. Imagine the following scenario:
To avoid issues such as the above, we recommend:
If SQL instance is only moved to other nodes of the cluster for a short period of time, such as for maintenance, you can simplify your backup scheme by only installing and configuring ZWC on a single primary node.
We encourage you to read following article posted on MSDN blog: What data should you backup from your SQL Server cluster?