Browse and Restore – SQL Server iDataAgent

Restore Data Browse and Restore
Table of Contents

Understanding the Restore Options Window

Browse provides an easy-to-use convenience to search and restore data.

You can open the browse and restore window from backup-set or subclient level. The sub levels displayed in the result window is based on where you start the browse operation.

Selecting Objects from the Restore Window for Restore

The restore window displays objects and consists of two parts:

  • The left pane displays the object tree at the selected level.
  • The right pane displays the contents of the selected object.

Note that the window displays only the data that was obtained by a backup. Data that is excluded by a filter, or data which did not exist as of the specified browse time does not appear in the window.

Selections follow these rules:
  • All selections are recursive.
  • Clicking a box again causes the selection to be cleared.
  • If you select an object in the left pane, then all of its contents are selected.
  • You can select a specific object in the right pane.

Selection status is revealed by the selection icons as follows:

Indicates that the object is not selected for restoration.
Indicates that a portion of the object is selected for restoration. i.e., only some of the child object(s) within the selected object.
Indicates that the entire object, including all of its child objects, are selected for restoration.

Browse and Restore Latest Data

Follow the steps given below to view the latest data backed up by a backup set:

  1. From the CommCell Browser, navigate to Client Computers | <Client> | SQL Server.
  2. Right-click the instance and then click All Tasks | Restore.
  1. Click OK.

    The latest data backed up by all the subclients is displayed in the Client Browse tab.

Browse and Restore Data before a Specified Backup Time

Follow the steps given below to browse the data backed up before specified time. This will display data from all cycles that fall under the specified time range.

  1. From the CommCell Browser, navigate to Client Computers | <Client> | SQL Server.
  2. Right-click the instance and then click All Tasks | Restore.
  1. Select Time Range.
  2. Under Absolute Time do the following:
    1. Select the Time Zone.

      For Oracle agents the default Time Zone is the client's time zone. For all other agents the default Time Zone is the CommServe time zone.

    2. Select End Time and enter a date and time to browse and restore data before it.
  3. Click View Content.

Browse and Restore Data between a Specified Backup Time

Follow the steps given below to browse data between specified time:

  1. From the CommCell Browser, navigate to Client Computers | <Client> | SQL Server.
  2. Right-click the instance and then click All Tasks | Restore.
  1. Select Time Range.
  2. Under Absolute Time do the following:
    • Select Start Time and enter a date and time.
    • Select End Time and enter a date and time.

    Data in between the time specified here will be browsed and restored.

  3. Click View Content.

Browse and Restore Data Backed Up in the Past n Days

You can specify a relative time for Browsing data for Restores. This provides flexibility in trawling backed up data from a wider time span rather than the need to remember an exact time range in which something was backed up.

Follow the step given below to Browse Data from a relative time:

  1. From the CommCell Browser, navigate to Client Computers | <Client> | SQL Server.
  2. Right-click the instance and then click All Tasks | Restore.
  1. Select Time Range and click Relative Time.
  2. Enter a number in the Last field and select Day, Week, Month or Year to browse and restore data.
  3. Click View Content.

Browse and Restore Databases or File and File Group

Using this option, you can select to browse only the Databases or only File/File Group in the browse results.

The following section describes how to perform the following action:

  1. From the CommCell Browser, navigate to Client Computers | <Client> | SQL Server.
  2. Right-click the instance and then click All Tasks | Restore.
  1. From the Restore Options dialog box, click Advanced Options.
  2. Select one of the following options:
    • Databases

      Selecting this option will display only databases in the browse results.

    • File/File Group

      Selecting this option will display only File/File Group in the browse results.

  3. Click OK.

Browse and Restore from Copies

By default, when a browse operation is requested, the software attempts to browse from the storage policy copy with the lowest copy precedence. If the data that you want to browse was already pruned from the primary copy, the software searches the other copies of the storage policy, starting from the copy with the lowest copy precedence to a copy with the highest copy precedence.

This feature is useful in the following conditions:      

  • The media containing protected data for a particular copy has been removed from the storage library, you can choose to browse from a copy whose media are inside the library.
  • Allows browsing from a copy that accesses faster disk media rather than slower tape media.
  • When media drives used by a particular copy are busy with another operation, this helps in browsing from a different copy to avoid resource conflicts.
  1. From the CommCell Browser, navigate to Client Computers | <Client> | SQL Server.
  2. Right-click the instance and then click All Tasks | Restore.
  1. From the Restore Options dialog box, click the Advanced Options tab.
  2. Select Browse from copy precedence checkbox and specify the preference number.

    If you specify a copy precedence number for a browse operation, the software searches only the storage policy copy with that precedence number in all storage policies used for securing the data. If data does not exist in the specified copy, the browse operation fails even if the data exists in another copy of the same storage policy.

  3. Click View Content.

List Media

List media option is useful to predict media required to restore the index required to browse data. This is useful when the index is not available in the index cache.
This option is also used to list media associated with data protection operations up to the specified date and time range.
This option is also used to list media associated with data protection operations up to the specified date and time range.

The following section describes how to perform this operation.

  1. From the CommCell Browser, navigate to Client Computers | <Client> | SQL Server.
  2. Right-click the instance and then click All Tasks | Restore.
  1. Click List Media.

    You can use the Latest Data to list media associated with the most recent data protection cycle.

    Or Specify Browse Time to list media associated with data protection operations up to the specified date and time range.

  2. From the List Media dialog box, click List Media for restore within specified time range.
  3. Click OK.
  4. The appropriate media is listed in the Media dialog box.