Page History
...
To use SQL Safe Today, click the SQL Safe Today globe icon in the task bartaskbar, or click click View > SQL SafeToday from the menu.
...
- 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)
...
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.
...
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.
...
| 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 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 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.
...
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 SQL Safe Backup 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. |