Page History
...
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. |
| 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 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. |
| Start Jobs for Policy | Allows you to run the backup jobs associated with this policy, performing an ad-hoc backup 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 Backup Policies node with the latest policies. |
From the Current Status pane
...
By right-clicking a backup operation, you can access the following shortcuts:
Action ... | What it does ... |
|---|---|
| Cancel | Allows you to cancel the backup policy. |
| View Details | Shows the Details pane, providing additional information about the selected backup operation such as Statistics, Result text, Files, Backup Set Description, Storage Options. |
| Back up again | Runs the backup operation again, using the same settings. |
| Back up with Different Options | Opens the Backup wizard (with all options pre-set to the values used for this operation), allowing you to specify different options before running the operation. |
| Verify backup | Verifies that the backup file is "good" and can be restored with all data intact. When you perform this operation a new operation is listed. If you right click Verify of the Operation column, you can Verify Again, Verify with Different Options, and Set Progress to different statuses. When you select Verify with Different Options, the SQL Safe Database Restore Wizard opens with the Verify option enabled. Use this wizard to set specific settings for this verify operation. |
| Restore database | Opens the Restore wizard, allowing you to restore this backup file. |
| Object Level Recovery | Opens the Object Level Recovery wizard allowing you to recover one or more objects, complete databases, or verify a backup. |
| Mount Virtual Database | Opens the Virtual Database wizard allowing you to mount a virtual database from a database backup set. |
| Set Progress To | Allows you to change the status of the selected operation to Complete, Complete, Warning, Error, Canceled, Skipped, or Deleted. |
What does the Current Status mean?
...
The Last Operation Status shows shows an overview of the most recent backup ocurred 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 backup operations performed by this policy. Click any backup operation to see more details about it, including the reasons for failed or skipped backup operations if applicable.
...
| 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. |
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. |
...