Creating a SQL Server Intelligent Policy
Before you configure an intelligent policy ensure that you have:
Registered the SQL Server instances that you want to protect.
See Registering a SQL Server instance or availability replica.
For SQL Server clusters or availability groups, you configured the mappings for distributed application restores. Also, you reviewed the auto-discovered mappings for the hosts in your environment.
See Configuring mappings for restores of a distributed applications, clusters, or virtual machines .
See Reviewing the auto-discovered mappings in Host Management.
To create a NetBackup for SQL Server Intelligent Policy
- Log on to the primary server as administrator (Windows) or root (UNIX).
- Start the NetBackup Administration Console.
- Expand NetBackup Management and select Policies.
- Select Actions > New > Policy.
- Type a unique name for the new policy and click OK.
- In the Policy type list, select MS-SQL-Server.
- Complete the entries on the Attributes tab.
Add other policy information as follows:
Choose to protect instances or instance groups.
If you choose the instances option, you can select either individual instances or databases.
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.
- When you have completed the policy configuration, click OK.
In the Applications utility, the properties for an instance, replica, or instance group indicate the name of any Intelligent Policies that protect those objects.