NetBackup™ Web UI Microsoft SQL Server Administrator's Guide

Last Published:
Product(s): NetBackup (10.1.1)
  1. About NetBackup for SQL Server
    1.  
      Overview of NetBackup for SQL Server
  2. Installation and host configuration
    1. Planning the installation of NetBackup for SQL Server
      1.  
        NetBackup server and client requirements
      2.  
        Requirements for using NetBackup for SQL Server in a NetBackup cluster
      3.  
        License for NetBackup for SQL Server
    2. Configuring SQL Server hosts and user permissions
      1.  
        Installing the Veritas VSS provider for vSphere
    3.  
      Configuring the NetBackup services for SQL Server backups and restores
    4.  
      Configure local security privileges for SQL Server
    5.  
      Assign an RBAC role to the SQL Server administrator
    6.  
      Configuring the primary server host name for the SQL Server agent
    7.  
      Configure the number of jobs allowed for backup operations
    8.  
      Configure the Maximum jobs per client setting
  3. Managing SQL Server discovery and credentials
    1. About discovery of SQL Server objects
      1.  
        Discover advanced or basic availability groups on demand
      2.  
        Discover databases on demand
      3.  
        Discover read-scale availability groups
    2. About SQL Server credentials
      1.  
        Add a credential for SQL Server
      2.  
        Select a credential for a SQL Server instance or replica
      3.  
        View the credential name that is applied to an asset
      4.  
        Edit or delete a named credential
    3.  
      Remove SQL Server instances
    4.  
      Manually add a SQL Server instance
  4. Managing protection plans for SQL Server
    1.  
      About protecting SQL Server availability groups
    2. Create a protection plan to protect SQL Server assets
      1.  
        Schedules
      2.  
        Performance tuning and configuration options
      3.  
        Using copy-only snapshot backups to affect how differentials are based
      4.  
        Snapshot methods
    3.  
      Protect a SQL Server availability group that crosses NetBackup domains
  5. Viewing SQL Server asset details
    1.  
      Browse SQL Server assets
    2.  
      View the protection status of databases, instances, or availability groups
  6. Protecting SQL Server
    1.  
      Add SQL Server assets to a protection plan
    2.  
      Customize protection settings for a Microsoft SQL Server asset
    3.  
      Remove protection from SQL Server assets
  7. Restoring SQL Server
    1.  
      Requirements for restores of SQL Server
    2.  
      Perform a complete database recovery
    3.  
      Recover a single recovery point
    4.  
      Options for SQL Server restores
    5.  
      Restore a database (non-administrator users)
    6.  
      Select a different backup copy for recovery
    7.  
      Restore a SQL Server availability database to a secondary replica
    8.  
      Restore a SQL Server availability database to the primary and the secondary replicas
  8. Using instant access with SQL Server
    1. Prerequisites when you configure an instant access SQL Server database
      1.  
        Hardware and configuration requirements of instant access
    2.  
      Things to consider before you configure an instant access database
    3.  
      Configure Samba users for SQL Server instant access
    4.  
      Configure an instant access database
    5.  
      View the livemount details of an instant access database
    6.  
      Delete an instant access database
    7.  
      Options for NetBackup for SQL Server instant access
    8.  
      NetBackup for SQL Server terms
    9.  
      Frequently asked questions
  9. Protecting SQL Server with VMware backups
    1. About protecting an application database with VMware backups
      1.  
        Limitations of VMware application backups
    2. Create a protection plan to protect SQL Server data with a VMware backup
      1.  
        Backup options and Advanced options
      2.  
        Exclude disks from backups
      3.  
        Snapshot retry options
    3.  
      Protect SQL Server data with a VMware backup
    4.  
      Restore SQL Server databases from a VMware backup
  10. Performance and troubleshooting
    1.  
      NetBackup for SQL Server performance factors
    2.  
      Troubleshooting credential validation
    3.  
      Troubleshooting VMware backups
    4.  
      SQL Server log truncation failure during VMware backups of SQL Server

About SQL Server credentials

To protect SQL Server, you must add (or register) credentials to the SQL Server instances or availability replicas. The NetBackup web UI supports Windows authentication and Windows Active Directory authentication. It does not support Mixed Mode or SQL Server authentication. Credentials are not supported at the database or the availability group level.

Table: Options to register credentials

Option to register credentials

Environment and configuration

Use these specific credentials (recommended)

  • The SQL Server DBA provides the NetBackup administrator with the SQL Server user credentials.

  • The SQL Server DBA does not want the NetBackup services running as a privileged SQL Server user on the client.

Configuration requirements

The user account that is used to register credentials must have the SQL Server "sysadmin" role and be a member of the Windows Administrators group.

The NetBackup services can use the Local System logon account. If you want to use a different logon account, that account must also have certain local security privileges.

Use credentials that are defined locally on the client

  • The NetBackup services run as a privileged SQL Server user on the client.

  • The SQL Server DBA does not want to provide credentials to register instances or replicas.

  • The NetBackup administrator does not have access to the SQL Server credentials.

  • You want to use gMSA credentials.

Configuration requirements

The user account that is used to register credentials must have the SQL Server "sysadmin" role and be a member of the Windows Administrators group.

You must also configure the logon account for the NetBackup Client Service and the NetBackup Legacy Network service.

 
Registering instances when SQL Server hosts are clustered or use multiple NICs

When NetBackup discovers a SQL Server cluster, it adds a single entry on the Instances tab. This instance represents all nodes in the cluster. The host name is the virtual name of the SQL Server cluster. When you add credentials for this instance NetBackup validates the credentials on the active node. The credentials must be valid for all nodes in the cluster.

When NetBackup discovers a SQL Server host that uses multiple NICs, it adds an entry using the NetBackup client name on the Instances tab. If you installed the NetBackup client using the public interface name, you must configure the NetBackup client name as the private interface name. Then add credentials to the instance with its private interface name. For a SQL Server cluster that uses multiple NICs, add credentials to the instance with the private virtual name of the SQL Server cluster.

Registering Microsoft SQL Server failover cluster instances (FCIs)

NetBackup discovers and displays failover cluster instances (FCIs) under the cluster name and the physical node names. For example, instance FCI is enumerated with both its physical nodes hostvm10 and hostvm11 and with its cluster name sql-fci. Databases that exist for FCIs are also enumerated with the node names and the cluster name. Depending on how you want to protect a database, add credentials to either the cluster name (that are valid for all nodes) or to a physical node name.

Validation of credentials

After you add credentials, NetBackup validates the credentials and starts the database and availability group discovery. When discovery completes, the results are displayed on the Databases or the Availability group tab.

For a SQL Server cluster or if an availability group instance is part of SQL Server cluster, NetBackup validates the credentials on the active node. The credentials must be valid for all nodes in the cluster. For a SQL Server availability group, replicas are registered and validated individually. Note that the registered date reflects the date and time the credential was added or updated. It does not indicate if the credentials are valid.