Configuring in a clustered environment
You can configure Data Protection for SQL Server to protect SQL Server workloads in an SQL Server cluster environment.
About this task
When you configure AlwaysOn Availability Groups (AAGs) in a Microsoft Windows failover cluster environment or in a Veritas cluster server cluster environment, follow these guidelines.
- Configure each node in the cluster identically. Specify identical configurations in the Data Protection for SQL Server options file.
- Ensure that each availability replica of an availability group is on a different node in the same Windows failover cluster environment.
- Use the Configuration Wizard to register an AlwaysOn Node on the IBM Spectrum Protectâ„¢ server. To do so manually, issue the register node command on the IBM Spectrum Protect server.
- To access a clustered SQL Server, identify the virtual server name and specify that name in Data Protection for SQL Server.
- If you use the IBM Spectrum Protect scheduler to automate data backups, install the scheduler service on each node of the cluster to enable failover support.
- Use the clustersharedfolder option in the Data Protection for SQL Server options file (dsm.opt) to specify the directory location in which to store encrypted password files. Specify a directory location that is on a resource that is shared among all nodes in the cluster. For more information, see Clustersharedfolder.