On this section of the SQL Safe Home tab, you can find a summary of your environment's alerts. SQL Safe groups these alerts by level of severity: OK (green), Informational (gray), Warning (yellow), Critical (red).
What actions can you perform on Alert Rules?
In each Alert rule, you can find the following options:
- Show Details - to view the complete list of instances or databases affected by the alert rule. Use the option Hide Details to display only the summarized form of the alert rule.
- Dismiss - to ignore the alert rule with their associated alerts.
- Refresh - to get the latest status of the alert rule.
What actions can you perform individually on each instance alert?
When you choose to Show Details of a specific alert rule, you can see all instances or databases associated with that specific alert rule. On each alert you can:
- Dismiss - to ignore the alert for that specific instance or database.
- Refresh - to get the latest status of that specific alert.
When you Dismiss an alert, it will not be displayed on the Home tab temporarily. SQL Safe will raise the alert when the alert rule condition triggers it again.
Additional options
According to the type of alert, you can find additional options, relevant to the alert, that can help you solve the situation:
- SQL Safe Backup Agent connection failures - you can select to Start/Restart the SQL Safe Backup Agent
- Safe Backup Agent should be upgraded - you can select to Upgrade SQL Safe Backup agent. When you select this option, SQL Safe opens a new window with the following options: Install SQL Safe Agent Extended Stored Procedures and Include Backup Service Install Log. Select your options and click OK to install them.
- Databases never been backed up - you have the following options:
- Add to Backup Policy - Use this option to select an existing policy. The wizard for the selected policy opens with the respective database added to the policy. Make any necessary changes or updates and save your policy.
- Create Backup Policy - Use this option to open the Create Policy Wizard. The respective Database will be added to the policy.
- For alerts showing Errors or Failed operations - you can perform the following options:
- Backup again.
- Backup with different options.
- Restore again - Click this option to execute the operation again with the previously defined options.
- Restore with different options - Click this option to open the Restore wizard and view the settings defined for the respective operation. You can review and change the restore options.
- Backup again.
Take into account that actions available for SQL Safe Backup connection failures and Databases never been backed up are only available for Administrators.
What other actions can you perform on the Alerts section?
SQL Safe allows you to perform the following actions on the Alerts section of the Home tab:
- Export - you can export your information in any of the following formats: PDF, XLS, or XML. Additionally, you can choose from one of the following options:
- Summary of recommendation categories - select this option to export all alert rules in their summarized version.
- Details for all recommendations - select this option to export all alert rules information including the details of the instances or databases that are associated with them.
- Details for selected categories - you can use this option to select those specific alert rule details you want to export.
- Hide Recommendations - use this option if you do not want to see the displayed alerts.
- Create Policy - Use this option to create: Backup Policies , Restore Policies or Log Shipping policies. This option is not available for Read-only users.
- Backup - Use this option to open the backup wizard.
- Restore - Use this option to select between restoring a database or performing an object level recovery.
- Additional options - Click the gear icon to access this wiki or check for updates.
What SQL Safe alerts can you find?
To find out more about what alerts SQL Safe notifies you about, go to Available Alerts and view the complete list of alerts, their description, severity level, and links to the respective knowledge base articles.