NetBackup™ Web UI Microsoft SQL Server Administrator's Guide

Last Published:
Product(s): NetBackup & Alta Data Protection (8.3.0.1, 8.3)
  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. Managing Microsoft SQL Server
    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 Microsoft SQL Server assets
    3. Select or add credentials to SQL Server instances or replicas
      1.  
        About Microsoft SQL Server credentials
      2.  
        Configuring the NetBackup services for SQL Server backups and restores
      3.  
        Configuring local security privileges for SQL Server
    4.  
      Manage Microsoft SQL Server credentials
    5.  
      Remove SQL Server instances
    6.  
      Manually add a SQL Server instance
  4. Protecting Microsoft SQL Server
    1.  
      Protect Microsoft SQL Server assets
    2. Edit protection settings for a asset
      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.  
      View the protection status of databases, instances, or availability groups
    4.  
      Remove protection from SQL Server assets
  5. Restoring Microsoft SQL Server
    1.  
      Perform a complete database recovery
    2.  
      Recover a single recovery point
    3.  
      Options for Microsoft SQL Server restores
    4.  
      Restore a SQL Server availability database to a secondary replica
    5.  
      Restore a SQL Server availability database to the primary and the secondary replicas
  6. Instant access
    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 an instant access database
    4.  
      View the livemount details of an instant access database
    5.  
      Delete an instant access database
    6.  
      Options for NetBackup for SQL Server instant access
    7.  
      NetBackup for SQL Server terms
    8.  
      Frequently asked questions

About discovery of SQL Server objects

NetBackup discovery runs regularly and gathers information for instances and for advanced and basic availability groups in your environment. (Read-scale availability groups must be discovered manually.) The data expires after one hour. The NetBackup Discovery Service (nbdisco) runs "shallow" discovery every 8 hours for instances and availability groups on the clients for that master server. The NetBackup Agent Request Service (NBARS) polls the master server every 5 minutes for any non-expired data.

Deep discovery includes discovery of databases and is performed in the following circumstances:

  • After a full backup, an incremental backup, or a restore occurs

    The client sends details when database data is changed and not more than every 15 minutes.

  • When you run a manual discovery of databases or availability groups

  • After you add credentials for the instances or replicas

By default, this service reports to the master server when it finds SQL Server instances. However, the user can turn off discovery for a specific client, with the bpsetconfig utility. See the REPORT_CLIENT_DISCOVERIES option in the NetBackup Administrator's Guide, Volume I.

The client maintains a cache file NB_instancename_cache_v1.0.dat in the NetBackup\dbext\mssql directory for each instance. The file can be deleted and NetBackup recreates it after the next full backup when deep discovery data is sent again.

Confirmation messages in the web UI

A message Starting the discovery of databases... displays after you click Discover databases or Discover availability groups. This message only indicates that a request was made to start the discovery process. However, database discovery can fail for different reasons. For example, if the instance is not associated with valid credentials or the host cannot be reached. You can consider the deep discovery is successful when the message displays: Successfully started the discovery of databases. Click Refresh to update the list.