Configuring the NetBackup services for SQL Server backups and restores (legacy SQL Server policies)
NetBackup uses the NetBackup Client Service and the NetBackup Legacy Network Service to access the SQL Server when it performs backups and restores. With the proper configuration, these services can log on with the Local System account or another account that has the necessary privileges.
The logon account for the services requires the following:
Both services must use the same logon account.
The SQL Server "sysadmin" role.
Apply the sysadmin role manually to the NT AUTHORITY\SYSTEM or the BUILTIN\Administrators group.
For a SQL Server cluster or SQL Server availability group, configure the NetBackup services on each node in the cluster or availability group.
For VMware backups, different configuration is required for logon account for the services.
See Configuring the NetBackup services for a VMware backup that protects SQL Server.
To configure the NetBackup services for SQL Server backups and restores
- Log on to the Windows host with the account that has the sysadmin role.
- If the SQL Server instance uses standard or mixed security, perform the following steps:
Open the NetBackup MS SQL Client.
Select File > Set SQL Server connection properties.
Provide the SQL Server Userid and Password.
Click Apply > Close.
- In the Windows Services application, open the NetBackup Client Service entry and click the Log On tab.
- Confirm that Local System account is selected.
If you selected a different logon account, stop and restart the service.
- Open the NetBackup Legacy Network Service entry and click the Log On tab.
- Confirm that Local System account.
If you selected a different logon account, stop and restart the service.