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

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.