Page History
The SQL Safe Today view provides an 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 the SQL Safe Todayglobe icon in the task bar, or click View > SQL SafeToday from 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 have
- that completed successfully)
- Number of policies whose status is not OK (includes a failed, skipped, or canceled operation)
- Number of successful operations
- Number of operation
- operations that failed (returned errors)
For more information, see How 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 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 see modify Total Cost of Operation (TCO) Preferencespreferences.
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 operationsRestore Operations
What can you find on the Policies status tab?
The Policies tab displays the current status of your Backup and Log Shipping policies.
...
| 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 TimeOperation | Displays the start date and time of the last backup operation executed by the policy. |
Last Backup Operation Failure Time | Displays the start time of the last failed backup operation executed by the policy. |
For more information, see Backup policies and How Log Shipping Policies workbackup 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.
...
| 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. | 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 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 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 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 | NewBackup 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 workbackup 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 | displayDisplay to the | settings viewSettings View. From | herethis view, you can | modifymanage your SQL Safe Backup Agent | settingsSettings. For more information about | agent settings, see View agent settings.Attach Virtual Database | If you have installed 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 | SQL virtual database, this will launch the SQL virtual database console. For more information about | SQL virtual database, see Recover objects using SQL virtual databasethe Object Level Recovery Wizard, see object level recovery operations. |
| Scroll pdf ignore | |||||||
|---|---|---|---|---|---|---|---|
| IDERA Website | Products | Purchase | Support | Community | About Us | Resources | Legal |
...