Create a SQL Server Intelligent Policy
This topic describes how to create an intelligent policy to protect SQL Server instances, databases, intelligent groups, or instance groups. Other topics cover how to protect availability groups and clusters.
See About protecting SQL Server availability groups.
See Configure backups of clustered SQL Server instances (SQL Server Intelligent Policy) .
To create 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 Register a SQL Server instance with an existing credential.
- Sign in to the primary server as a user that has the RBAC Administrator role or a role that can manage policies.
- On the left, select Protection > Policies.
- Select the Add button.
- Type a unique name for the new policy.
- In the Policy type list, select MS-SQL-Server.
- Complete the entries on the Attributes tab.
Add other policy information as follows:
On the Instances and databases tab, choose how you want to protect SQL Server.
If you choose the Protect instances and databases 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. You cannot use intelligent groups to perform filegroup or file backups.
(Optional) Make changes to any tuning parameters.
- When you have completed the policy configuration, select Create.
In the Workloads > Microsoft SQL Server utility, the properties for an instance or database indicate the name of any intelligent policies that protect those objects.