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

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 Server 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 the 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 live mount share in gnome?

If the automount is enabled, the source folder is mounted from the live mount 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 live mount 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 SQL Server instant access works on specific windows clients?

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 username and password.

    Ensure that the username 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 logon 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 logon password. The 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 username and password.

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