Configuring backups of clustered SQL Server instances (SQL Server Intelligent Policy)
This procedure describes how to protect SQL Server clustered instances 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 master server or on a NetBackup remote client console that acts for the master 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)
- Open the NetBackup Administration Console.
- 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 Protect instances.
- Add the instances or databases that you want to protect.
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.
(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 master 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 this property in Host Management on the master server.
See Reviewing the auto-discovered mappings in Host Management.