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

Frequently asked questions

Here are some frequently asked questions for Microsoft SQL instant access Build Your Own (BYO).

Table:

Applicable for

Frequently asked question

Answer

BYO

How can I enable the Microsoft SQL instant access feature on BYO after storage is configured or upgraded without the nginx service installed?

Perform the steps in the following order:

  1. Install the required nginx service version.

  2. Ensure that the new BYO nginx configuration entry: /etc/nginx/conf.d/byo.conf is part of the HTTP section of the original: /etc/nginx/nginx.conf file.

  3. Run the command: /usr/openv/pdde/vpfs/bin/vpfs_config.sh --configure_byo

BYO

How can I resolve the following issue in the vpfs-config.log file that is raised from: Verifying that the MSDP REST API is available via https on port 10087

Perform the steps in the following order:

  1. Install the policycoreutils and policycoreutils-python packages through yum tool.

  2. Add the following rules that SELinux for Nginx requires to bind on the 10087 port.

    • semanage port -a -t http_port_t -p tcp 10087

    • setsebool -P httpd_can_network_connect 1

  3. Run the following command: /usr/openv/pdde/vpfs/bin/vpfs_config.sh --configure_byo

BYO

Instant Access for BYO uses a self-signed certificate by default and only supports *.pem external certificate.

How do I replace it with a certificate signed by external CA (*.pem certificate), if required?

To configure the external certificate, perform the following steps. If the new certificate is already generated (the certificate must contain long and short host names for the media server), go to step 4.

  1. Create the RSA public or private key pair.

  2. Create a certificate signing request (CSR).

    The certificate must contain long and short host names for the media server.

  3. The External Certificate Authority creates the certificate.

  4. Replace <PDDE Storage Path>/spws/var/keys/spws.cert with the certificate and replace <PDDE Storage Path>/spws/var/keys/spws.key with the private key.

  5. Run the following command to reload the certificate:

    /usr/openv/pdde/vpfs/bin/vpfs_config.sh --configure_byo

BYO

How can I disable media automount for the instant access livemount share in gnome?

If the automount is enabled, the source folder is mounted from the livemount share in gnome and smaller disks appear. In this scenario, the instant access feature does not work properly.

The mounted disk content source is from the .../meta_bdev_dir/... folder under livemount share, while the mount target is in the /run/media/... folder.

Follow the guideline to disable the gnome automount:

https://access.redhat.com/solutions/20107

BYO

How can I resolve the following issue in the /var/log/vpfs/vpfs-config.log file?

**** Asking the NetBackup Webservice to trust the MSDP webserver (spws) **** /usr/openv/netbackup/bin/nblibcurlcmd failed (1):

Perform the steps in the following order:

  1. Ensure that your NetBackup primary server is up and there is no firewall blocking the connection between the NetBackup primary server and storage server.

  2. Run the following command on storage server to verify the connection status:

    /usr/openv/netbackup/bin/bpclntcmd -pn

  3. After the NetBackup primary server is up and connection between the NetBackup primary server and storage server is allowed, run the following command:

    /usr/openv/pdde/vpfs/bin/vpfs_config.sh --configure_byo

BYO and Flex Appliance

How can I enable host-based authentication and secure logon for Samba share so that the MSSQL instant access works on specific windows clients?

The clients windows version and the background are listed at the following link:

https://support.microsoft.com/en-us/help/4046019/guest-access-in-smb2-disabled-by-default-in-windows-10-and-windows-ser

Perform the steps in the following order:

  1. In the storage server (one time operation) where the Samba share is exported from:

    • Override the following Samba option to disable the guest logon:

      map to guest = Never

    • Create user credentials for Samba.

      • smbpasswd -a spws

        Set Samba password for Samba user spws

      • smbpasswd -e spws

        Enable Samba user spws

  2. For each Windows client, where the Samba share is accessed using the earlier credentials, save the spws credentials in the credential manager.

  3. To save the samba credentials on a Windows client, open go to Control Panel > User Accounts > Credential Manager > Add a Windows Credential..

  4. In Internet or network address, enter the storage server domain name.

  5. Enter the samba user name and password.

    Ensure that the user name is same as the user credentials that you created for Samba.

  6. Click OK and ensure that you can access <storage server domain name> without a login prompt.

NetBackup Appliance

How can I enable host-based authentication and secure logon for Samba share so that the MSSQL instant access works on NetBackup Appliance and windows clients?

Perform the steps in the following order:

  1. In the storage server (one time operation) where the Samba share is exported from, create new local user credentials for Samba with the following Appliance CLISH path:

    Main_Menu > Settings > Security > Authentication > LocalUser

  2. In each Windows client, where the Samba share is accessed using the earlier credentials, save the new local user credentials in the credential manager.

For Appliance, the smb.conf file configuration already contains map to guest = Never.

The local users are added to samba database automatically and the samba password is the same as the login password. Windows clients can access the appliance's samba share using credentials of the appliance's local users.

Perform the steps in the following order:

  1. To manage appliance local users, go to the following CLISH path:

    Main_Menu > Settings > Security > Authentication > LocalUser

  2. To save the samba credentials on a Windows client, open go to Control Panel > User Accounts > Credential Manager > Add a Windows Credential.

  3. In Internet or network address, enter the storage server domain name.

  4. Enter the samba user name and password.

  5. Click OK and ensure that you can access <storage server domain name> without a login prompt.