Page History
...
What actions can you perform?
From the Restore Policies tree
By right-clicking a policy under the the Restore Policies node node, you can access the following shortcuts:
Action ... | What it does ... |
|---|---|
Create Restore Policy | Opens the Restore Policy wizard, allowing you to create a new policy. |
Edit Policy | Opens the Restore Policy wizard (with all options pre-set to the values used for this operation), allowing you to edit any of the options. |
| Copy Policy | Opens the Backup Policy wizard (with all options pre-set to the values used for this operation), allowing you to create a copy of it. |
Delete Policy | Allows you to delete the policy. Although restore operations associated with this policy will no longer be performed, the previous status messages returned by this policy will continue to be stored in the SQL Safe Repository. |
| Disable Policy | Allows you to disable |
| the selected policy. Restore operations associated with this policy will no longer be performed. | |
Start Jobs for Policy | Allows you to run the restore job associated with this policy, performing an ad-hoc restore with the options already set by the policy. |
| View Out of Date Jobs | Allows you to view jobs that are out of date. |
| Update Out of Date Jobs | Allows you to update the list of out of date jobs. |
Refresh Policy List | Updates the Restore Policies node with the latest policies. |
From the Current Status pane
...
Action ... | What it does ... |
|---|---|
| View Policy Settings | Allows you to view a summary of the policy settings. |
Edit Policy | Opens the Restore Policy wizard, allowing you to change your policy settings. |
Disable Policy | Disables the selected policy. Once a policy is disabled, it will no longer perform restore operations for the associated databases. To recover a database that belongs to a disabled policy, perform a manual restore using the Restore Wizard. |
Start Full Restore | Performs a full restore of all databases that belong to this policy by running the corresponding job. This action applies to your previously defined policy settings. |
...
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. If an operation completed with warnings, this column will display a yellow bar labeled 100% with an asterisk. This column also indicates when the backup file has been deleted (groomed), and therefore is no longer available to be restored. |
| Instance | Displays the name of the SQL Server instance that was backed up or restored by this operation. |
Icon (Enhanced Restorability) | Displays an icon if the backup includes maps containing metadata for InstantRestore and SQL virtual database. For more information about InstantRestore, see How InstantRestore works. For information about SQL virtual database, see recover objects using SQL virtual database. |
| Database | Displays the name of the database that was backed up or restored by this operation. |
| Operation | Displays the type of operation performed. The types are Backup, Restore, and Verify. |
| Backup Type | Displays the type of |
| backup performed by the operation. The types are Full, Log, Differential, and File. | |
| Compressed | Displays the size of the backup file after compression. |
| Ratio | Displays the ratio of the Uncompressed size of the database reported by SQL Server to the resulting Compressed size of the backup file created by SQL Safe. |
| Compression | Displays the type of compression used for the backup. |
| Database Size | Displays the size of the original database. |
| Uncompressed | Displays the size of data contained in the database, as reported by SQL Server. |
| Encryption | Displays the type of encryption SQL Safe used during the backup operation. |
| Duration | Displays the time ( hours:minutes:seconds ) required to complete the operation. |
| Start Time | Displays the start date and time of the operation. |
| End Time | Displays the end date and time of the operation. |
| Threads | Displays the number of threads SQL Safe used during the backup operation. |
| Format | Displays the backup format. SQL Safe backup (Safe) or native backup (Bak) format. |
Can you customize the columns in the Operation Details grid?
...