Configure backups of clustered SQL Server instances (batch file-based policies)
This procedure describes how to protect SQL Server clustered instances with a batch file-based policy. Perform these steps after you create the virtual SQL Server (VIRTUALSERVER). The following actions must be performed on the primary server or on a NetBackup remote client console that acts for the primary server.
If you have a SQL Server cluster with multiple NICs, you must follow a different procedure.
See Configure backups of a SQL Server cluster when you have multiple NICs (batch file-based policies).
To configure backups of clustered SQL Server instances
- Create a policy (for example, VIRTSQLPOLICY).
- On the Attributes tab, configure the following:
Select the MS-SQL-Server policy type.
Specify a storage unit. If you use a virtual media server, then specify a storage unit that belongs to the virtual media server.
- On the Instances and databases tab, select Clients for use with batch files.
- On the Schedules tab, add an automatic backup schedule.
- On the Clients tab, add the virtual SQL Server name (VIRTUALSERVER).
- On the Backup selections tab, add one or more script names (batch files).
- Map the virtual name of the SQL Server cluster to each node in the cluster.
Configure these mappings in the Distributed application restore mapping host property on the primary server.
See Configuring mappings for restores of a distributed applications, clusters, or virtual machines .
- Configure the mapped host names for the SQL Server hosts in your environment.
Configure these mappings in Security > Host mappings on the primary server.