Requirements for restores of SQL Server
To restore perform restores of SQL Server, the following requirements exist:
NetBackup services are correctly configured.
Both administrators or non-administrators can perform restores. However, additional configuration steps are required for non-administrators.
Administrators must provide during the restore a user account that is a member of the Windows administrator group and a member of the local SQL Server sysadmin role.
Non-administrators must follow these additional steps for successful recovery:
The user that signs into the NetBackup web UI is assigned to the RBAC role or another role with the same restore permissions for SQL Server.
See Default RBAC roles and role permissions in the NetBackup Web UI Administrator's Guide. Or, contact your NetBackup administrator for assistance.
The security administrator has configured the necessary mappings for the hosts in .
Refer to the information on configuring host mappings in the NetBackup Web UI Administrator's Guide. Or, contact your NetBackup administrator for assistance.
To restore to a different server (host), the following requirements and conditions exist:
NetBackup must have the ability to communicate with the destination client.
Non-administrator users can only perform restores from their own backups.