NetBackup™ Web UI Microsoft SQL Server Administrator's Guide

Last Published:
Product(s): NetBackup (9.1)
  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
  4. Monitoring NetBackup
    1.  
      The NetBackup dashboard
    2.  
      Monitoring jobs
    3.  
      Filter jobs in the job list
  5. 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.  
      Browse SQL Server assets
    3.  
      About SQL Server credentials
    4.  
      Add credentials to SQL Server instances or replicas
    5.  
      Manage SQL Server credentials
    6.  
      Remove SQL Server instances
    7.  
      Manually add a SQL Server instance
  6. 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 and retention
      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
  7. Protecting SQL Server
    1.  
      Add SQL Server assets to a protection plan
    2.  
      Edit protection settings for a Microsoft SQL Server asset
    3.  
      View the protection status of databases, instances, or availability groups
    4.  
      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
    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. Troubleshooting
    1.  
      Troubleshooting credential validation
    2.  
      Troubleshooting VMware backups and restores of SQL Server
    3.  
      SQL Server log truncation failure during VMware backups of SQL Server

Planning the installation of NetBackup for SQL Server

Table: Installation steps for NetBackup for SQL Server shows the installation steps that are required to run NetBackup for SQL Server.

Table: Installation steps for NetBackup for SQL Server

Step

Action

Description

Step 1

Verify the operating system and platform compatibility.

See the NetBackup Compatibility Lists.

Step 2

Verify that primary server has a valid license for NetBackup for SQL Server and any NetBackup options or add-ons that you want to use.

 

Step 3

Install the NetBackup client software on the computers that have the databases that you want to back up. The NetBackup for SQL Server agent is installed with the NetBackup client software.

To use the new features that are included in NetBackup for SQL Server in NetBackup 9.1, upgrade your NetBackup for SQL Server clients to NetBackup 9.1. The NetBackup media server must use the same version as or a higher version than the NetBackup for SQL Server client.

Note the following:

  • For SQL Server availability groups, install the client on each replica in the availability group where you want backups to occur.

  • In a SQL Server cluster environment, install the NetBackup client on each node in the cluster. Each node must have the same version of NetBackup.

  • In a VMware environment, install the NetBackup client software on the virtual machines that have SQL Server running.

  • If you have multiple NICs, install the NetBackup client using the private interface name.

  • If the SQL Server client is on a different host than the primary server or media server, then install the NetBackup client on that host.

Step 4

To protect a read-scale availability group, you must have the SQL Server Native Client version 11.0.7462 ODBC driver or later installed on the availability group replicas.

This version of the driver lets you discover and browse databases on a read-scale availability group.

Step 5

To use NetBackup for SQL Server in a NetBackup cluster, verify that your cluster environment is supported and that the NetBackup cluster is configured correctly.

Review the following requirements:

  • The NetBackup server software is installed and configured to work in a NetBackup cluster.

  • The NetBackup client software is installed and operational on each node to which NetBackup can failover.

  • A valid license must exist for NetBackup for SQL Server on each node where NetBackup server resides.

See the Software Compatibility List (SCL).

See the NetBackup Installation Guide.

See the NetBackup Clustered Master Server Administrator's Guide.