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

Configuring local security privileges for SQL Server

If you use the option Use these specific credentials to create a credential, an account other than Local System requires certain local security privileges. These privileges are necessary since the NetBackup for SQL Server agent logs on as the SQL Server user when it accesses data.

Note:

This configuration applies to local security privileges only. For domain-level privileges, contact your domain administrator.

To configure the local security privileges

  1. Open the Local Security Policy.
  2. Click Local Policies.
  3. In the User Rights Assignment, add the account to the following policies:

    • Impersonate a client after authentication

    • Replace a process level token

  4. Run the group policy update command (group policy update) for this change to take effect:

    gpupdate /Force

  5. If the NetBackup Client Service and the NetBackup Legacy Network Service use this account to log on, restart these services.
  6. For a SQL Server cluster, configure the local security privileges on each node in the cluster. For SQL Server availability groups, configure the services on all replicas where you want to run backups.