Loading...

Managing Databases Using the Web Console

Table of Contents

Overview

Use the Manage Databases function to view a list of SQL servers that you own. You can manage the SQL databases associated with the SQL agent subclients by running queries to generate reports, creating new snapshots, and managing clones.

You cannot view or access servers that you do not own.

Cloning SQL Databases

You can clone a SQL database to create a temporary, identical copy on the same instance or another instance. Use the clone as a testing environment for quick data retrieval, for running reports, or when you do not want to put an additional load on the production database.

About This Task

You can clone an SQL database from the latest, existing, or new SnapProtect jobs.

Before You Begin

  • You must have the Execute permission on the Snap-CreateTestClone workflow. For information on adding permissions to a workflow, see Configuring Workflow Permissions.
  • Ensure that you clone a database that is SnapProtect-protected and linked. A linked database implies that the database resides in a subclient and has SnapProtect enabled and in which the snap engine is NetApp or Nimble.
  • Ensure that the destination instance of the clone database has the same or later SQL version than the source instance.
  • Ensure that the subclient is associated with the database that you want to clone.

Procedure

  1. From the Web Console, on the My Applications page, click Manage Databases.
  2. On the Servers page, click the server that manages the SQL databases that you want to clone.
  3. On the Databases page, click the database that you want to clone.
  4. On the Clones page, click Create Clone.
  5. In the Create Clone dialog box, select the type of SnapProtect job from which the database is cloned.
    1. To create a clone from the latest SnapProtect job run, click Latest Snap.
    2. To create a clone from an existing SnapProtect job in a time range, click Existing Snap.

      Enter the date range in which the job was run, and click Next. In the Job ID box, select the snap job, and click Next.

    3. To create a clone from a database which has not yet been backed up, click New Snap.

      The size of a database that is not backed up is displayed as zero.

      To clone the database, you must first run a new SnapProtect backup job on the subclient, and then create a clone from the new snapshot.

  6. Click Next.
  7. Select the destination client and the destination instance where you wish to create the clone database. Provide a name and expiration date for the clone database.
  8. Click Create New Clone.

Result

A job is submitted for clone creation and a progress bar is displayed on your screen. Once the job is complete, the clone is successfully created.

Changing the Expiration Date of Clone SQL Databases

You can extend or shorten the expiration date of one or more clone databases.

Before You Begin

You must have the Execute permission on the Snap-TestCloneOperations workflow. For information on adding permissions to a workflow, see Configuring Workflow Permissions.

Procedure

  1. From the Web Console, on the My Applications page, click Manage Databases.
  2. On the Servers page, click the server that manages the clone databases whose expiration date you want to change.
  3. On the Databases page, click the database link.
  4. On the Clones page, select one or more clones whose expiration date you want to extend or shorten.
  5. Click the Extend  button.
  6. Select a new expiration date, and click Submit.

Deleting Clone SQL Databases

You can delete a clone which is old or corrupted. If you have a recent version of a clone database then you can delete its older versions.

Before You Begin

You must have the Execute permission on the Snap-TestCloneOperations workflow. For information on adding permissions to a workflow, see Configuring Workflow Permissions.

Procedure

  1. From the Web Console, on the My Applications page, click Manage Databases.
  2. On the Servers page, click the server that manages the clone databases that you want to delete.
  3. On the Databases page, click the database link.
  4. On the Clones page, select one or more clones for deletion.

    Click the Delete button.

  5. Click Yes to confirm.

Filtering SQL Databases

Use the filter function to search for a particular SQL server, SQL database or SQL clone database. You can filter the list so that only the data that you require appears in the list. For example, you can filter out all the clones with the same expiration date. For more information, see Content, Filters, and Regular Expressions - Backup.

  1. From the Web Console, on the Servers, Databases or Clones page, click the Filter  button.

    Blank text boxes appear below the table headers in each column.

  2. In the text boxes, type the parameter by which you want to filter the servers, databases or clones. Filtered results are displayed in the table below.

Creating a Report for SQL Databases

Note: This procedure is currently unavailable.

You can query the databases or the clones to build your own reports. Use this feature to create reports for your data, to create a report from multiple databases, to share reports with the other users, to export reports in other file formats, and so on.

  1. From the Web Console, on the Databases or Clones page, select a database and click the Query Database button.
  2. From the Build New Report page, build, save, and share the report.

    For more information, see Build Your Own Reports.

    Select Data Sources and Select Database are selected by default and cannot be changed.