Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

To use SQL Safe Today, click the  SQL Safe Todayglobe icon in the task bar, or click click View > SQL SafeToday from the menu.

What is the Status Summary?

...

  • 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 see How policies work .

Why are SQL Safe Today statistics different than Server statistics?

...

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

...

When the Policies tab is selected, all existing policies are displayed with the following columns:

Column HeaderDefinition

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.

...

When the Backup & Restore Operations tab is selected, all existing operations are displayed with the following columns:

Column HeaderDefinition

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?

...

The Common Tasks are shortcuts to some of the more frequently performed actions in SQL Safe.

TaskDefinition

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.


Scroll pdf ignore
SQL Safe is a high-performance backup and recovery solution for your SQL Servers. Learn more > >