NetBackup™ Web UI Microsoft SQL Server Administrator's Guide
- Introducing the NetBackup web user interface
- About NetBackup for SQL Server
- Managing Microsoft SQL Server
- Protecting Microsoft SQL Server
- Restoring Microsoft SQL Server
- Instant access
- Prerequisites when you configure an instant access SQL Server database
Configuring the NetBackup services for SQL Server backups and restores
For policies and protection plans with the NetBackup web UI, NetBackup uses the NetBackup Client Service and the NetBackup Legacy Network Service to access the SQL Server when it performs backups and restores.
Note the following requirements for the NetBackup services logon account:
The account must have the SQL Server "sysadmin" role.
If you want to use Local System for the logon account, apply the SQL Server sysadmin role manually to the NT AUTHORITY\SYSTEM or the BUILTIN\Administrators group.
To configure the NetBackup services for SQL Server backups and restores
- Log on to the Windows host with the account that has the SQL Server sysadmin role and any necessary local security privileges.
- In the Windows Services application, open the NetBackup Client Service.
- Confirm that Local System account or a SQL Server administrator account is configured.
If you use the setting Use credentials that are defined locally on the client to register instances, both services must use the same logon account. If you use the setting Use these specific credentials to register instances, the services can use the same logon or separate logon accounts.
- Open the NetBackup Legacy Network Service.
- Confirm that Local System account or a SQL Server administrator account is configured.
If you use the setting Use credentials that are defined locally on the client to register instances, both services must use the same logon account. If you use the setting Use these specific credentials to register instances, the services can use the same logon or separate logon accounts.
- If you selected a different logon account, restart the services.
- If you selected the option Use these specific credentials, an account other than Local System requires certain local security privileges.