Veritas NetBackup™ for Microsoft SQL Server Administrator's Guide
- Introducing NetBackup for SQL Server
- Installing NetBackup for SQL Server
- Instance Management for SQL Server Intelligent Policies
- Viewing the SQL Server instances and instance groups in instance management
- About registering SQL Server instances
- Configuring SQL Server backups with SQL Server Intelligent Policy
- Configuring NetBackup for SQL Server
- Performing restores of SQL Server
- Redirecting a SQL Server database to a different host
- Restoring multistreamed SQL Server backups
- Protecting SQL Server data with VMware backups
- About protecting SQL Server data with VMware backups
- Using NetBackup for SQL Server with Snapshot Client
- Using copy-only snapshot backups to affect how differentials are based
- About SQL Server agent grouped backups (legacy SQL Server policies)
- Protecting SQL Server in high availability (HA) environments
- About using NetBackup to protect SQL Server availability groups
- About protecting the preferred replica in a SQL Server availability group (legacy backup policies)
- About protecting a specific node in a SQL Server availability group
- About NetBackup for SQL Server with database mirroring
- Backup and recovery concepts
- Overview of SQL Server backup and recovery concepts
- About recovery factors for SQL Server
- Using NetBackup for SQL Server with multiple NICs
- Configuring backups with legacy SQL Server policies using clients and batch files
- About using batch files with NetBackup for SQL Server
- About schedule properties
- Backing up read-only filegroups
- Performing user-directed operations with dbbackex
- Using bplist to retrieve a list of SQL Server backups
- SQL Server backups and restores in an SAP environment (legacy SQL Server policies)
- About SQL Server backups and restores in an SAP environment
- Troubleshooting
- About debug logging for SQL Server troubleshooting
- Disaster recovery of a SQL Server
- Appendix A. Sample batch files
- About sample backup batch files for legacy SQL Server policies
- About sample restore batch files
- About sample backup batch files for legacy SQL Server policies
- Appendix B. Multiplexed backups
- Appendix C. Register authorized locations
Configuring the NetBackup services for SQL Server backups and restores
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:
The SQL Server "sysadmin" role.
If you want to use Local System for the logon account, the requirements depend on the SQL Server version:
For SQL Server 2008, the sysadmin role is automatically applied to the NT AUTHORITY\SYSTEM and BUILTIN\Administrators groups.
For SQL Server 2012 and later, you must first apply the sysadmin role manually to the NT AUTHORITY\SYSTEM or the BUILTIN\Administrators group.
For a SQL Server cluster, configure the NetBackup services on each node in the cluster.
Additional requirements depend on the credentials option you chose to register the instance(s).
For
, the NetBackup services can use the Local System logon account. If you want to use a different logon account, it must have the privileges to and .See Configuring local security privileges for SQL Server.
Both services can use the same logon account or separate logon accounts.
For
, the logon account for the services can be either the SQL System administrator or Local System. Both services must use the same logon account.
For VMware backups, different configuration is required for logon account for the services.
See Configuring the NetBackup services for VMware backups that protect 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 and any necessary local security privileges.
- Open the Windows Services application.
- Double-click the NetBackup Client Service entry.
- Click the Log On tab.
- 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.
- Click OK.
- Double-click the NetBackup Legacy Network Service entry.
- Click the Log On tab.
- 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.
- Click OK.
- If you selected a different logon account, restart the services.
See About credentials used with SQL Server Intelligent Policy.