On the the Policies tab tab, you can see all the existing existing SQL Safe policies policies in your environment. For each policy, you can see the following information:
- Status Status - displays the status of the operations for each database The status are: wait, failed, missed, skipped, cancelled, completed with warnings, or succeeded.
- Policy Type - displays the type of policy: backup, restore, or log shipping.
- Policy Name - displays the name with which the policy was created.
- Databases Covered - displays the number of databases covered by the policy.
- Instances Covered - displays the number of instances covered by the policy.
- Last Operation - displays the last operation executed in the policy.
- Last Operation with Failure - displays the last failed operation in the policy.
| Tip |
|---|
Keep in mind: - You can sort the information available on this tab by clicking the column header by which you want to order your instances.
- You can set the number of items you want to view per page by going to the lower section of the list grid, type a number in the box, and the page will be updated according to your requirements.
|
How do you filter your information?
In order to get more specific policy information from your environment, you can use the Filtering section on the left side of the Policies tab.
You can filter your information by:
- Status - select the status of the policies you want to view. The status are: most severe operation status. In other words, in order to get a Succeeded status, all operations for each database and operation type should have completed successfully without any errors. These statuses can be:
- Wait - no operations have been performed for the policy.
- Failed Failed - the last policy operation for one or more databases failed.
- Missed Missed - one of the last scheduled policy operations for one or more databases did not start as scheduled.
- Skipped Skipped - one of the last scheduled policy operations for one or more databases were skipped.
- Cancelled Cancelled - one of the last scheduled policy operations for one or more databases were cancelled by the user.
- Completed with warnings warnings - one of the last scheduled policy operations for one or more databases completed with warnings.
- Succeeded Succeeded - all of the last operations for each database and operation type completed successfully.
- Policy Type Type - displays select the type of policy: Backup, Restore, or Log Shipping.
- Policy NameName - type the name with which the policy was created. Click the name to access the Policy Properties.
- Databases Covered - the number of databases covered by the Covered - use the From and To options to set specific range of databases you want to filter by policy.
- Instances Covered - the number of instances included in the Covered - use the From and To options to set specific range of instances you want to filter by policy.
- Last Operation Operation - select the date using the date and time of Calendar. On the From and To options, set specific date range to filter the last operation executed in the policy.
- Last Operation with Failure Failure - the date and time of the select the date using the Calendar. On the From and To options, set specific date range to filter the last failed operation in the policy.
How can you filter your information?
In order to get more specific policy information from your environment, you can use the Filtering section on the left side of the Policies tab. You can filter your information by Status, Policy Type, Policy Name, Databases Covered, Instances Covered, Last Operation, Last Operation with Failure, Instances, and Databases.
- Instance - type the name of the instance under which the policy is running under.
- Database - type the name of the database under which the policy is running under.
| Tip |
|---|
When using filters take into account: - You can save your filtering options
|
| Tip |
|---|
You can save your custom filtering option - by selecting your filters, typing a name in the
text box under - By Custom Filter field, and clicking
ADD FILTER- Add Filter. To retrieve your saved filters, click the
name of the filter you created. |
| Tip |
|---|
When using filters take into account:- drop-down option in the By Custom Filter section and select your filter name.
- If you want to select filters first and apply the changes later, unselect the option deselect the Apply filter as it changes option.
- To remove filters, use the specific Remove Filter option in each filter. For example, if you want to remove your Instance Status filters, click Remove STATUS Status Filter under the same filter section.
- Under Under APPLIED FILTERS on on the top section or your Policies Policies tab, you can see the filters you have selected. Click the X icon next to the ones you want to remove.
- Use the option Clear on the top section of the Filtering section to remove all filters.
|
What other options are available from the Policies tab?
The Policies tab tab allows you to perform the following actions located on the upper section of this tab:
- Add SQL Server instance - click this option to register new servers. Go to Adding adding SQL Server instances to to find more information about registering new instances.
- Create Policypolicy - use this option to access the wizard for creating Backup, Restore, or Log Shipping policiescreating backup, restore, or log shipping policies.
- Edit Policypolicy - select one of the available policies and click this option to edit its configuration settings.
- Copy Policypolicy - this option allows you to select an existing policy and create a copy. When you select this option, the Policy Wizard opens with the selected policy settings. You can change these settings according to your preferences. Take into account you have to specify a different name for the copy.
- Actions - use this option to enable the policy, disable the policy, or to Run a Backup.
- Properties - select this option to access the summary details of a selected policy. You can also use this option to change the configuration settings of a policy.
- Remove/Deletedelete - select a policy from the list of available policies and click this option to delete it. You can select to delete only the policy or also the jobs associated with the policy.
- Export - click this option to export the displayed information on the Policies tab. You can select exporting your information in PDF, XLS, or XML file.