When Backup Policies is selected in the Policies tree pane, the content pane displays information describing the overall status of all of these policies. Use this view to quickly determine whether your servers are in compliance with your corporate backup policies.

What does the Current Status mean?

The Current Status displays the most recent, combined status of all operations performed by your backup policies. Even though there are multiple operation statuses, the overall policy status reflects the most critical operation status. When all backups have been completed successfully according to the policy schedule, a green OK icon is displayed.

What is the Last Operation Status?

The Last Operation Status shows an overview of the most recent backup, restore, or log shipping operations that occurred across your enterprise. Use this view to quickly determine whether your servers are in compliance with your corporate policies.

What is the Operation Summary?

The Operation Summary displays a listing of all policies, providing information in the following columns:

Column HeaderDefinition
StatusDisplays either a green OK status bar, a yellow warning status bar, or a red error status bar.
NameDisplays the policy name.
Databases CoveredDisplays the number of databases being backed up by the policy.
Last Backup TimeDisplay the date and time of the most recent backup operation (of any type defined by the policy).
Last Backup Failure TimeDisplays the date and time of the most recent backup failure (of any type defined by the policy).

How do you get details about a specific policy?

You can get more details about the status of a specific policy by double-clicking on one of the policy operations in the Operation Summary grid or by choosing the respective policy on the Backup Policies folder tree node.

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 the Refresh icon in the pane title bar.

SQL Safe is a high-performance backup and recovery solution for your SQL Servers. Learn more > >
  • No labels