The SQL Safe Today view provides a high-level record of backup and recovery operations across your enterprise.
Use this view to monitor the status of backup and restore operations and easily access the most commonly used tasks. This view automatically displays when you start the Management Console.
How do you access SQL Safe Today?
To use SQL Safe Today, click the SQL Safe Today tab on the top of the navigation pane, or click View > SQL SafeToday from the menu.
What is the Status Summary?
The Status Summary provides a simple indicator to tell you at a glance whether backup and restore operations across your enterprise have been successful. The green check icon indicates success, and the red X icon indicates errors have occurred.
What are the Status Details?
The statistics pane shows the values for the following metrics:
- Number of policies whose status is OK (all operations that completed successfully)
- Number of policies whose status is not OK (includes a failed, skipped, or canceled operation)
- Number of successful operations
- Number of operations that failed (returned errors)
For more information, see how policies work.
Why are SQL Safe Today statistics different than Server statistics?
The filter used by the SQL Safe Today statistics is different than that used by the Servers statistics. SQL Safe Today shows the status for all instances and databases. Servers show status based on your filter settings plus the currently selected node and the databases under it.
What is Disk Space Savings?
The disk space savings pane shows the disk space savings achieved by using compression on your backup sets, and, using the TCO/GB parameter set in the SQL Safe Preferences, calculates your return on investment (ROI) using SQL Safe for your SQL Server instance backups. For more information on calculating TCO, see modify Total Cost of Operation (TCO) preferences.
What tabs are available on the SQL Safe Today view?
There are two tabs available for you to choose from on the SQL Safe Today view:
- Policies
- Backup and Restore Operations
What can you find on the Policies status tab?
The Policies tab displays the current status of your Backup and Log Shipping policies.
When the Policies tab is selected, all existing policies are displayed with the following columns:
| Column Header | Definition |
|---|---|
Status | Status can be ok, warning, or error. |
Name | Displays the policy name. |
Databases Covered | Displays the number of databases covered by the policy. |
Last Operation | Displays the start date and time of the last operation executed by the policy. |
Last Operation Failure | Displays the start time of the last failed operation executed by the policy. |
For more information, see backup policies, restore policies, and log shipping policies.
What can you find on the Backup & Restore Operation status tab?
The Backup & Restore Operations tab displays the current status of the backup and restore operations that were scheduled to run today.
When the Backup & Restore Operations tab is selected, all existing operations are displayed with 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%. When an operation is completed with errors, this column will display a red bar labeled Error. This column also indicates when the backup file has been deleted (groomed), and therefore is no longer available to be restored. |
Instance | Displays the instance name that was backed up or restored by this operation. |
Database | Displays the database name that was backed up or restored by this operation. |
Operation | Displays the operation performed. The options are Backup, Restore, and Verify. |
Backup Type | Displays the type of backup performed by the operation. The options are Full, Log, Differential, and File. |
Start Time | Displays the start date and time of the operation. |
Duration | Displays the number of seconds required to complete the operation. |
Can you customize the columns in the grid?
You can sort the content of any column by clicking on the column header.
How do you refresh the operations status?
If a recent operation does not appear in the status view, you can refresh the status of this pane by clicking on the refresh icon in the pane title bar.
What are the Common Tasks?
The Common Tasks are shortcuts to some of the more frequently performed actions in SQL Safe.
| Task | Definition |
|---|---|
Register SQL Server | Allows you to add a new SQL Server instance. For more information about Registering SQL Server Instances, see register an instance. |
Backup Database | Starts the SQL Safe Backup Wizard, which allows you to back up one or more databases. For more information about the Backup Wizard, see perform a manual backup. |
Restore Database | Starts the SQL Safe Restore Wizard, which allows you to restore one or more databases. For more information about the Restore Wizard, see restore a database. |
| Mount Virtual Database | Starts the SQL Safe Virtual Database Wizard, which allows you to mount a virtual database from a database backup set. For more information about the Mount Virtual Database Wizard, see mount a virtual database. |
| Create Backup Policy | Starts the SQL Safe Backup Policy Wizard, which allows you to create a new backup policy. For more information about the Backup Policy Wizard, see backup policies. |
| Create Restore Policy | Starts the SQL Safe Restore Policy Wizard, which allows you to create a new restore policy. For more information about the Restore Policy Wizard, see restore policies. |
| Manage Agents | Changes the Console Display to the Settings View. From this view, you can manage your SQL Safe Backup Agent Settings. For more information about the SQL Safe Backup Agents, see install and configure the SQL Safe Backup Agent. |
| Object Level Recovery | Starts the SQL Safe Object Level Recovery Wizard, which allows you to recover one or more objects from backup databases. For more information about the Object Level Recovery Wizard, see object level recovery operations. |