NetBackup™ Web UI Microsoft SQL Server Administrator's Guide

Last Published:
Product(s): NetBackup & Alta Data Protection (10.0)
  1. Introducing the NetBackup web user interface
    1.  
      About the NetBackup web UI
    2.  
      Terminology
    3.  
      Sign in to the NetBackup web UI
    4.  
      Sign out of the NetBackup web UI
  2. About NetBackup for SQL Server
    1.  
      Overview of NetBackup for SQL Server
  3. Installation and host configuration
    1.  
      Planning the installation of 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.  
      Configuring the primary server host name for the SQL Server agent
    6.  
      Configuring the number of jobs allowed for backup operations
    7.  
      Configuring the Maximum jobs per client setting
  4. 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
  5. 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
  6. Viewing SQL Server asset details
    1.  
      Browse SQL Server assets
    2.  
      View the protection status of databases, instances, or availability groups
  7. 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
  8. 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
  9. Using instant access with SQL Server
    1. Prerequisites when you configure an instant access SQL Server database
      1.  
        Hardware configuration requirement 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
  10. 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
  11. 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

Select a credential for a SQL Server instance or replica

To allow for full discovery of SQL Server assets, you must select the credential that you want to use for the instances or replicas. You can select from the existing server credentials or create a new credential.

Review the recommendations and requirements for the type of credentials that you want to use for authentication.

See About SQL Server credentials.

See Select an existing credential for a SQL Server instance or replica.

See Add a new credential for a SQL Server instance or replica.

Select an existing credential for a SQL Server instance or replica

For availability groups, each replica in must be registered with credentials.

To select an existing credential for a SQL Server instance or replica

  1. On the left, click Workloads > Microsoft SQL Server.
  2. Click on the Instances tab.
  3. Select the check box for the instances or replicas and click Manage credentials.
  4. Click Select from existing credentials.
  5. Click Next.
  6. Select the credential that you want to use for the selected assets and click Next.
  7. The database and the availability group discovery begin after the credentials are validated. However, these assets may not appear in the web UI immediately. They appear after the discovery process completes. Note that the dates reflect when the credential was added or updated; it does not indicate if the credential is valid.

Add a new credential for a SQL Server instance or replica

For availability groups, each replica in must be registered with credentials.

To add a new credential for a SQL Server instance or replica

  1. On the left, click Workloads > Microsoft SQL Server.
  2. Click on the Instances tab.
  3. Select the check box for the instances or replicas and click Manage credentials.
  4. Select Add credentials and click Next.
  5. Select one of the following authentication options:

    • Use credentials that are defined locally on the client

    • Use these specific credentials

      Provide the User name, password, and Domain that is associated with the credentials.

    See About SQL Server credentials.
  6. The database and the availability group discovery begin after the credentials are validated. However, these assets may not appear in the web UI immediately. They appear after the discovery process completes. Note that the dates reflect when the credential was added or updated; it does not indicate if the credential is valid.