The Notifications tab of the Log Shipping Policy wizard allows you to choose from which log shipping status you want to receive alert notifications. Email notifications let you, and your staff, remotely monitor the status of the backups and restores you have automated with this policy. The status of the log shipping operations determine the status of your policy. When your backups and restores are successfully completed on schedule, the policy is considered okay.

Choose the status you want to monitor, type the email address of each recipient, select the desired alert frequency for each operation, and then click Next .

You must configure your mail server settings before SQL Safe can send email notifications. Click Configure E-mail to check your settings. For more information, see Configure e-mail settings for alert notifications.

When is the email sent?

SQL Safe sends an email to the specified recipients when the selected operation status occurs. Because SQL Safe checks the status of your backup and restore operations every minute, your alert notifications provide a real-time indication of the health of your log shipping policy and your primary and secondary servers.

However, how often SQL Safe notifies about a specific status update depends on the notification frequency you select. For example, if you want to receive an email whenever a restore fails, even when the failures occur sequentially, choose to receive notifications every time the event occurs.

After defining your setting in this tab, click Next to define settings for the log shipping policy.


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

  • No labels