NetBackup™ Web UI Microsoft SQL Server Administrator's Guide

Last Published:
Product(s): NetBackup & Alta Data Protection (10.3.0.1, 10.3)
  1. About NetBackup for SQL Server
    1.  
      Overview of NetBackup for SQL Server
    2.  
      Detailed features for 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.  
      Add SQL Server assets to a protection plan
    4.  
      Customize protection settings for a Microsoft SQL Server asset
    5.  
      Remove protection from SQL Server assets
    6.  
      Protect a SQL Server availability group that crosses NetBackup domains
  5. Configuring backup policies with Snapshot Client
    1.  
      About NetBackup Snapshot Client for SQL Server
    2.  
      How SQL Server operations use Snapshot Client
    3.  
      Snapshot methods
    4.  
      Configuration requirements for SQL Server snapshot and Instant Recovery backups
    5.  
      Configure a snapshot policy for SQL Server
    6.  
      Configure a policy for Instant Recovery backups of SQL Server
    7. Using copy-only snapshot backups to affect how differentials are based
      1.  
        Creating a copy-only backup (legacy SQL Server policies)
      2.  
        Creating an Instant Recovery backup that is not copy-only (legacy SQL Server policies)
    8. About SQL Server agent grouped snapshots
      1.  
        Restoring a database backed up in a group
  6. Viewing SQL Server asset details
    1.  
      Browse SQL Server assets
    2.  
      View the protection status of databases, instances, or availability groups
  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

Detailed features for NetBackup for SQL Server

Table: NetBackup for SQL Server features

Feature

Description

Integration with NetBackup role-based access control (RBAC)

The NetBackup web UI provides RBAC roles to control which NetBackup users can manage SQL Server operations in NetBackup. The user does not need to be a NetBackup administrator to manage SQL Server operations. However, the user still must be a member of the Windows administrator group and have the SQL Server "sysadmin" role.

Protection plans and SQL Server Intelligent Policy

The following benefits are included:

  • Use a single protection plan or an intelligent policy to protect the following: Multiple SQL Server instances, instance databases, availability groups, or availability databases. Instances can be spread over multiple clients.

  • Include a full, differential, and transaction log backup in the same protection plan or policy.

  • Schedule frequent backups of transaction logs.

  • You are not required to know SQL Server commands or to write and use batch files. Instead, this feature automatically generates the batch files at run-time.

Management of SQL Server assets

NetBackup automatically discovers SQL Server instances and availability groups in the environment. You can also perform manual discovery.

After instances or replicas are registered, the SQL Server workload administrator can protect the SQL Server assets with a policy or protection plan.

Authentication and credentials

SQL Server protection plans and SQL Server Intelligent Policy support the following:

  • Windows authentication

  • Windows Active Directory authentication

  • With the proper configuration, you do not have to run the NetBackup service account as a privileged SQL Server user on the client.

Backup and restore features

The following features are available for backups and restores:

  • Backups and are managed entirely by the NetBackup server from a central location. Administrators can schedule automatic, unattended backups for instances on local or remote hosts across the network.

  • The NetBackup web UI supports the backup and restore of databases and transaction logs from one interface.

    Note: SQL Server recovery with the web UI requires that the SQL Server client is at version 8.3 or later.

  • Backup schedules for full, differential, or transaction log backups.

  • Manual backups and copy-only backups.

  • Backups and restores of only read-write filegroups. This features is able with policy-based backups.

  • Support for high availability (HA) environments, including SQL Server clusters and availability groups.

  • Restore SQL Server objects to different locations (redirected restores).

  • Ability to use multiple stripes during a backup.

  • Tuning options that can improve the performance of backups.

Recovery points

The web UI provides recovery points from which you can easily perform various recovery operations. If instant access is configured, you can also create an instant access database from a recovery point.

Stream-based backups and restores

Stream-based backup and restore of SQL Server objects with SQL Server's high-speed virtual device interface.

Snapshot backups and instant access databases

NetBackup can perform backups of SQL Server with snapshot methodology. Backups with policies also offer off-host backups, Instant Recovery, and backups with a hardware provider.

You can also create an instant access database from a NetBackup backup image. The database is available almost instantaneously, achieving a near-zero recovery time objective. NetBackup mounts the database's snapshot directly on the backup storage device and treats the snapshot as a normal database.

Support for VMware backups that protect SQL Server

VMware protection plans and VMware intelligent policies offer support for application-consistent, full backups of VMware computers using snapshots. The VMware intelligent policy also supports Replication Director (RD) snapshots.

Use of NetBackup Accelerator can increase the speed of backups.

See the following for more information.

Use Accelerator to back up virtual machines

Application protection options (VMware)

NetBackup Replication Director Solutions Guide

Legacy SQL Server policies

Support for the legacy backup policies that use batch files and a list of clients.