Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

When a specific restore policy is selected from the Restore Policies tree node, the content pane displays information describing the status of that policy. Use this view to determine which restore operations initiated by the policy have succeeded or failed.

What actions can I perform?

From the Policies tree

By right-clicking a policy under the  Restore Policies node, you can access the following shortcuts:

...

Action ...

What it does ...

View DetailsShows the  Details  pane, providing additional information about the selected operation.

Restore again

Runs the restore operation again, using the same settings.

Restore with different options

Opens the Restore wizard (with all options pre-set to the values used for this operation), allowing you to specify different options before running the operation.

Set Progress To

Allows you to change the status of the selected operation.

Close DetailsHides the Details pane.

What does the Current Status mean?

The Current Status displays the most recent, combined status of the restore operations performed by this policy. When there are multiple operation statuses, the policy status reflects the most critical operation status. When all restores have been completed successfully according to the policy schedule, a green ok icon is displayed.

What is the Last Operation Status?

The Last Operation Status shows an overview of the most recent backup, restore, or log shipping operations that occurred across your enterprise. Use this view to quickly determine whether your servers are in compliance with your corporate policies. The operation status is limited to restore operations performed by this policy.

What are the Operation Details?

The Operation Details grid displays a listing of all restore operations performed for the databases included in the selected policy for the last 7 days. This grid includes the following columns:

Column

Definition

Progress

During an operation, the progress bar will denote the percentage of the operation completed. When the operation is complete, it will display a green bar labeled 100%. If an operation completed with errors, this column will display a red bar labeled Error.

Instance

Displays the instance name that was restored by this operation.

Database

Displays the database name that was restored by this operation.

Operation

Confirms that a restore operation was performed.

Backup Type

Displays the type of backup restored by the operation. Currently, only the recovery of full backups is supported by the restore policy.

Compressed

Displays the compressed file size of the backup used in this restore.

Ratio

Displays the percentage of the data that was compressed in the associated backup.

Compression

Displays the type of compression that was used for the associated backup.

Duration

Displays the number of seconds required to complete the restore operation.

Start Time

Displays the start date and time of the restore operation.

Can you customize the columns in the Operation Details grid?

You can sort by the content of any of the columns by clicking the column header.

You can select which columns are visible in this grid, and enable column grouping, by clicking the  Filter icon in the pane title bar.

How do you refresh the data displayed in the Operation Details grid?

If a recent operation does not appear in the status view, you can refresh the status of this pane by clicking the  Refresh icon in the pane title bar.

What are the details?

To see the detailed results of a specific operation, right-click the operation in the Operation Details grid and select View Details. The Details pane displays below. By default, this pane is hidden.

...