Configure backups of clustered SQL Server instances (SQL Server Intelligent Policy)
This procedure describes how to protect SQL Server instances that are clustered with a SQL Server Intelligent 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.
To configure backups of clustered SQL Server instances (SQL Server Intelligent Policy)
- 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, choose if you want to protect instances and databases, intelligent groups, or instance groups.
- Add the assets that you want to protect.
See Add intelligent groups to a policy.
For a clustered instance, the host name is the virtual name of the SQL Server cluster.
Add other policy information as follows:
Add schedules.
(Optional) Select the specific filegroups or files that you want to back up. By default, NetBackup backs up an entire database. Filegroup and file backups are not available for any policies that use intelligent groups.
(Optional) Make changes to any tuning parameters.
- 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.