NetBackup™ for Microsoft SQL Server Administrator's Guide
- About NetBackup for SQL Server
- Installation
- Host configuration and job settings
- Installing the Cohesity VSS provider for vSphere
- Configuring RBAC for SQL Server administrators
- Managing SQL Server assets and their credentials
- About discovery of SQL Server objects
- About registering SQL Server instances
- About credential rules
- About intelligent groups
- Configuring backups with SQL Server Intelligent Policy
- Performance tuning and configuration options
- Protecting SQL Server availability groups
- Protecting SQL Server availability groups with intelligent policies
- Protecting SQL Server availibility groups with batch file-based policies
- About protecting the preferred replica in a SQL Server availability group (batch file-based policies)
- About protecting a specific node in a SQL Server availability group (batch file-based policies)
- About protecting the preferred replica in a SQL Server availability group (batch file-based policies)
- Protecting SQL Server with VMware backups
- About protecting an application database with VMware backups
- Create a protection plan to protect SQL Server data with a VMware backup
- Configuring backup policies with Snapshot Client
- Using copy-only snapshot backups to affect how differentials are based
- About SQL Server agent grouped snapshots
- Protecting SQL Server in a cluster environment
- Managing protection plans for SQL Server
- Restoring SQL Server with the NetBackup web UI
- Using instant access with SQL Server
- Prerequisites when you configure an instant access SQL Server database
- Configuring batch-file based policies for SQL Server backups
- Requirements to use batch files with NetBackup for SQL Server
- Schedule properties for SQL Server batch file-based policies
- Configure a batch file-based policy for a user-directed backup of read-only filegroups
- Performing backups and restores with the NetBackup MS SQL Client
- Redirect a SQL Server database to a different host (NetBackup MS SQL Client)
- Restoring multistreamed SQL Server backups
- Using NetBackup for SQL Server with multiple NICs
- Performance and troubleshooting
- About debug logging for SQL Server troubleshooting
- About disaster recovery of SQL Server
- Appendix A. Other configurations
- About SQL Server backups and restores in an SAP environment
- About NetBackup for SQL Server with database mirroring
- Appendix B. Register authorized locations
Add a credential rule
You can add a credential rule so that unregistered or newly discovered instances are automatically registered with a credential.
To add a credential rule
- Select the Credential rules tab.
- Select Add or Add credential rule.
- Provide the Name and Description for the rule.
- Select Add condition.
- To select the criteria for the rule, make the following selections from the menus.
Start by making a selection for the Field list.
Then make a selection for Operator.
For the Value field, select or enter the value.
For details on the query criteria, see the following topics.
- Add any additional conditions or sub-queries for the rule.
- (Optional) To see the instances that match the rule criteria, select the Preview button. See the following topic for details.
- Select Next.
- Select from the following options:
Select from existing credentials
Select the credential that you want to apply to the credential rule.
Only the credentials with the type Microsoft SQL Server display.
Add credentials
Enter the Credential name and select the authentication option. Then select Next.
See Authentication options for SQL Server credentials.
Add any RBAC roles or permissions that you want to apply to the new credential.
- Select Add.
Any unregistered or any newly discovered instances that meet the rule criteria are registered with the associated credential in the rule. If you have the necessary RBAC permissions, you can view the instances that were registered in the audit messages. (Go to Security > Security events. Then select the Audit events tab.)