When Log Shipping 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 log shipping policies.

What does the Current Status mean?

The Current Status area displays the most recent, combined status of all backup and restore operations performed by your log shipping policies. Even though there are multiple operation statuses, the overall policy status reflects the most critical operation status. When all backups and restores have been completed successfully according to the policy schedule, a green okay 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. Click the status to see more detail about your operations.

What is the Operation Summary?

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

Column Header

Definition

Status

Displays either a green Compliant status bar, or a red Non-Compliant status bar.

Name

Displays the policy name.

Databases Covered

Displays the number of databases being backed up by the policy.

Last Operation

Display the date and time of the most recent operation (of any type defined by the policy).

Last Operation Failure

Displays the date and time of the most recent 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 the policy operation in the Operation Summary grid.

Can you customize the columns in the grid?

You can sort by the content of any of the columns by clicking 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