Microsoft SQL Server assets

Permissions for Microsoft SQL Server assets allow users to view, protect, and restore SQL Server assets using the NetBackup for SQL Server agent.

Note:

To perform discovery, backups, and restores, valid credentials must exist for an availability group or an instance.

Table: Permissions for SQL Server assets

Operation	Description	Additional required operations
View	View availability groups, instances, and databases.
Create	Manually add instances.	View
Update	Update asset details. Add or update credentials for availability replicas or instances.	View
Delete	Delete availability replicas or instances.	View
Manage access	See Manage access.	View
Restore to alternate location	Restore a database to an alternate server. This permission is required for all SQL Server "MOVE" operations.	View Restore
Discover availability groups	Manually discover availability groups. To perform discovery, valid credentials must be added to one of the availability group replicas.	View
Discover databases	Manually discover databases. To perform discovery, valid credentials must be added to the instance.	View
Instant access	Create an instant access database.	View Restore
Allow restore to overwrite	Overwrite a SQL Server database if it exists.	View Restore
Protect	Add SQL Server assets to or remove them from protection plans.	View
Restore	Restore databases to the original location, a different database, or a different instance.	View
Validate credentials	Validate credentials when they are added (assigned) to an instance or a replica. This permission is required on the asset.	On the asset these additional permissions are needed: View Update On the credential the following permissions are needed: Credentials > View Credentials > Assign credentials