NetBackup™ Web UI Microsoft SQL Server Administrator's Guide

Last Published:
Product(s): NetBackup (10.2)
  1. About NetBackup for SQL Server
    1.  
      Overview of 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.  
        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
  5. Viewing SQL Server asset details
    1.  
      Browse SQL Server assets
    2.  
      View the protection status of databases, instances, or availability groups
  6. Protecting SQL Server
    1.  
      Add SQL Server assets to a protection plan
    2.  
      Customize protection settings for a Microsoft SQL Server asset
    3.  
      Remove protection from SQL Server assets
  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

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.

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.