Page History
...
When Backup Policies is selected in the Policies tree pane, the content pane displays information describing the overall status of
...
all of these policies. Use this view to
...
What actions can you perform?
From the Policies tree
By right-clicking on a policy under the Backup Policies node, you can access the following shortcuts:
...
Action ...
...
What it does ...
...
Create Backup Policy
...
Opens the Backup Policy wizard, allowing you to create a new policy.
...
Edit Policy
...
Opens the Backup Policy wizard (with all options pre-set to the values used for this operation), allowing you to edit any of the options.
...
Delete Policy
...
Allows you to delete the policy. Although backup operations associated with this policy will no longer be performed, the previous backup files and status messages created by this policy will continue to be stored in the SQL Safe Repository.
...
Disable Policy
...
Allows you to disable the selected policy. Backup operations associated with this policy will no longer be performed and will turn off any email notifications you have configured to alert on the backup or restore status.
...
Refresh Policy List
...
Updates the Backup Policies node with the latest policies.
From the Current Status pane
By clicking the links available in the Current Status pane, you can access the following shortcuts:
...
Action ...
...
What it does ...
...
Edit Policy
...
Opens the Backup 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 backup operations for the associated databases. To back up a database that belongs to a disabled policy, perform a manual backup using the Backup wizard.
...
Start Full Backups
...
Performs a full backup of all databases that belong to this policy by running the corresponding job. This action applies your previously defined policy settings, and is only available when your policy includes a full backup operation.
...
Start Diff Backups
...
Performs a differential backup of all databases that belong to this policy by running the corresponding job. This action applies your previously defined policy settings, and is only available when your policy includes a differential backup operation.
...
Start Log Backups
...
Performs a transaction log backup of all databases that belong to this policy by running the corresponding job. This action applies your previously defined policy settings, and is only available when your policy includes a log backup operation.
quickly determine whether your servers are in compliance with your corporate backup policies.
From the Operation Details grid
By right-clicking a backup operation, you can access the following shortcuts:
...
Action ...
...
What it does ...
...
What does the Current Status mean?
The Current Status displays the most recent, combined status of
...
all operations performed by
...
your backup policies. Even though there are multiple operation statuses, the overall policy status reflects the most critical operation status. When all backups 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.
...
What is the Operation Summary
...
?
The Operation
...
Summary displays a list of all policies, providing information in the following columns:
| Column Header | 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 backed up by this operation.
Icon
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 database name that was backed up by this operation.
Operation
Displays the operation performed. The options are Backup and Verify.
Backup Type
Displays the type of the backup performed by the operation. The options are Full, Transaction Log, Differential, and File.
Compressed
Displays the compressed file size of the backup.
Ratio
Displays the percentage of the data that was compressed.
Compression
Displays the type of compression that was used for this backup.
Duration
Displays the number of seconds required to complete the operation.
Start Time
| Status | Displays either a green OK status bar, a yellow warning status bar, or a red error status bar. |
| Name | Displays the policy name. |
| Databases Covered | Displays the number of databases being backed up by the policy. |
| Last Operation | Display the date and time of the most recent backup operation (of any type defined by the policy). |
| Last Operation Failure | Displays the date and time of the most recent backup failure (of any type defined by the policy). |
How do you get details about a specific policy?
You can get more details about the status of a specific policy by double-clicking on one of the policy operations in the Operation Summary grid or by choosing the respective policy on the Backup Policies folder tree node.
Can you customize the columns in the
...
grid?
You can sort the content of any of the columns by clicking on 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
...
operations status?
...
If a recent operation does not appear in the
...
operation summary 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, click the operation in the Operation Details grid. The Details pane displays below. By default, this pane is hidden.
The Details pane provides the following information about the selected backup operation:
...
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 your total cost of operation (TCO).
...
Result Text
...
Displays text describing the result of the backup.
...
Files
...
Displays the complete path of the backup set file for the backup.
...
Backup Set Description
...
Displays the description you specified for this backup.
...
Storage Options
...
.
| Scroll pdf ignore |
|---|
SQL Safe is a high-performance backup and recovery solution for your SQL Servers. Learn more > > |
...