The SQL Safe Today view provides an 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 globe icon in the task bar, 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 have completed successfully)
- Number of policies whose status is not OK (includes a failed, skipped, or canceled operation)
- Number of successful operations
- Number of operation 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 shows 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 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, or display a warning or error state. |
Name | Displays the policy name. |
Databases Covered | Displays the number of databases covered by the policy. |
Last Backup Time | Displays the start date and time of the last backup executed by the policy. |
Last Backup Failure Time | Displays the start time of the last failed backup executed by the policy. |
For more information, see Backup policies and How Log Shipping Policies work.
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 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. |
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 or restored by this operation. |
Operation | Displays the operation performed. The options are Backup, Restore, and Verify. |
Backup Type | Displays the type of the 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 by the content of any of the columns 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. |
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. |
Create New 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 How backup policies work. |
Manage Agents | Changes the Console display to the settings view. From here, you can modify your SQL Safe Agent settings. For more information about agent settings, see View agent settings. |
Attach Virtual Database | If you have installed SQL virtual database, this will launch the SQL virtual database console. For more information about SQL virtual database, see Recover objects using SQL virtual database. |