Page History
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:
|
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:
- Wait
- 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 and time of date using the 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.
- policy.
- 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 |
---|
Tip |
When using filters take into account: |
When using filters take into account:
|
Tip |
|
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.
SQL Safe is a high-performance backup and recovery solution for your SQL Servers. Learn more > >
...