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\mssqlfolderHKLM\SOFTWARE\ODBCregistry hiveinstall_path\NetBackup\logs\user_opsfolder
Restore a database (non-administrator users)
- Before you can perform a restore, you must do the following:
Add the non-administrator credentials to the SQL Server instance.
See Select a credential for a SQL Server instance or replica.
Perform a new backup of the database.
Locate the database and click Action > Backup Now.
- When you perform the restore, provide the credentials that you used to register the instance.