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 of 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. |
...
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 wizardWizard. |
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 is completed with errors, this column will display a red bar labeled Error. If an operation is 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. | |
| 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 |
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
| . | |
| 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?
You can sort by the content of any of the columns by clicking the column header.
...
Tab | Description |
|---|---|
Statistics | Displays the database size, the size of the uncompressed backup, the size of the compressed backup, and the compression ratio achieved with this backup. The ratio is a measure of the storage savings achieved with SQL Safe compression technology. For more information about the storage space savings, you can realize using SQL Safe, see Understand see understand your total cost of operation (TCO). |
Result Text | Displays text describing the result of the restore. |
Files | Displays the complete path of the backup set file for the restore. |
Backup Set Description | Displays the description you specified for this restore. |
Storage Options | Displays which locations were chosen to store the backup files associated with the restore. |