Restore a database (non-administrator users)

Non-administrators can perform restores of SQL Server. However, additional requirements and configuration steps are required.

The following requirements exist for a non-administrator:

Is a member of the domain users group.
Has the sysadmin role on the local SQL Server.
Has full access control to the following:
- install_path\NetBackup\dbext\mssql folder
- HKLM\SOFTWARE\ODBC registry hive
- install_path\NetBackup\logs\user_ops folder

Before you can perform a restore, you must do the following:
- Add the non-administrator credentials to the SQL Server instance.
  See Register a SQL Server instance with an existing credential.
  See Register a SQL Server instance with a new credential.
  See Add a credential rule.
- Perform a new backup of the database.
  Locate the database and click Actions > Backup Now.
When you perform the restore, provide the credentials that you used to register the instance.