NetBackup™ Web UI Microsoft SQL Server Administrator's Guide

Last Published:
Product(s): NetBackup (9.0.0.1, 9.0)
  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 and notifications
    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 SQL Server availability database to a secondary replica
    6.  
      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

Configure an instant access database

Configure an instant access database and then start the database

You can configure an instant access database from a full, a transaction log, or an incremental backup. You can choose to add the database automatically to the SQL Server instance.

To configure an instant access database and then start the database

  1. On the left, click Microsoft SQL Server.
  2. On the Databases tab, click the database for which you want to configure the instant access database.
  3. Click the Recovery points tab, then click the date on which the backup occurred.

    The available images appear in rows with the backup timestamp for each image.

  4. Right-click on the backup image and click Actions > Configure instant access.
  5. (Conditional) For a full backup, after the instant access database is created you can add the database to the instance and start the database. Click Yes > Next for this option.
  6. (Conditional) For a transaction log, select a replay option and click Next.
  7. Review the recovery target and host name, instance name and make any wanted changes.

    To change the host and instance, click Change instance.

  8. In the Database name field, enter the instant access database name that you want to create.
  9. Enter the username and password of the SQL Server instance for the recovery target.
  10. Review the recovery options and make changes if needed and then click Next.

    See Options for NetBackup for SQL Server instant access.

  11. (Optional) To view a list of the backup images for the selected recovery point, click the link that displays the number of backup images.
  12. Review the summary of the selected recovery target and recovery options. Then click Start recovery.
  13. After the instant access job starts, you can click on the Restore activity tab to view the progress.

    See View the livemount details of an instant access database.

Configure an instant access database, but not start the database

You can configure an instant access database from a full backup. If you do not want to start the instant access database after it is created, you can enter the host name or select the name where you want to create the instant access database. After the instant access database is created, the database is not added to the instance but exported to a Samba share.

To configure an instant access database, but not start the database

  1. On the left, click Microsoft SQL Server.
  2. On the Databases tab, click the database for which you want to configure the instant access database.
  3. Click the Recovery points tab, then click the date on which the backup occurred.

    The available images appear in rows with the backup timestamp for each image.

  4. Right-click on the backup image and click Actions > Configure instant access.
  5. If you want to add the database to the instance and start the database, choose No > Next.
  6. Select one of the following options for the recovery target:
    • To enter the recovery target host name, click Enter host name.

    • To select from a list of hosts, click Select host name

  7. (Optional) To view a list of the backup images for the selected recovery point, click the link that displays the number of backup images.
  8. Click Start recovery.
  9. After the instant access job starts, you can click on the Restore activity tab to view the progress.

    See View the livemount details of an instant access database.