Adding a new 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.
SQL Server clusters, 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 application, cluster, or virtual machine .
See Reviewing the auto-discovered mappings in Host Management.
To add a new NetBackup for SQL Server Intelligent Policy
- Log on to the master server as administrator (Windows) or root (UNIX).
- Start the NetBackup Administration Console.
- If your site has more than one master server, choose the one on which you want to add the policy.
- In the left pane, expand NetBackup Management and select Policies.
- Select Actions > New > Policy.
- For the Policy name, type a unique name for the new policy.
- 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.