Page History
...
From the Log Shipping Policies tree
By right-clicking a policy under the the Log Shipping Policies node node, you can access the following shortcuts:
Action ... | What it does ... |
|---|---|
Create Log Shipping Policy | Opens the Log Shipping Policy wizard, allowing you to create a new policy. |
Edit Policy | Opens the Log Shipping wizard (with all options pre-set to the values used for this operation), allowing you to edit any of the options. |
| Copy Policy | Opens the Backup Policy wizard (with all options pre-set to the values used for this operation), allowing you to create a copy of it. |
Delete Policy | Allows you to delete the policy. Although backup operations associated with this policy will no longer be performed, the previous backup files and status messages created by this policy will continue to be stored in the SQL Safe Repository. |
Disable Policy | Allows you to disable |
the selected policy. Backup and restore operations associated with this policy will no longer be performed and email notifications configured on these jobs will be turned off. | |
Re-Initialize Secondary Database | Allows you to re-initialize any of the secondary databases associated with the selected policy. |
| View Out of Date Jobs | Allows you to view jobs that are out of date. |
| Update Out of Date Jobs | Allows you to update the list of out of date jobs. |
Refresh Policy List | Updates the Log Shipping Policies node with the latest policies and their statuses. |
From the Current Status pane
...
Action ... | What it does ... |
|---|---|
| View Policy Settings | Allows you to view a summary of the policy settings. |
Edit Policy | Opens the Log Shipping Policy wizard, allowing you to change your policy settings. |
Disable Policy | Disables the selected policy. Once a policy is disabled, it will no longer ship transaction logs to the secondary databases and it will no longer send email notifications configured for the respective jobs. |
Start Log Backups | Performs a transaction log backup of the primary database that belongs to this policy by running the corresponding job. This action applies to your previously defined policy settings. |
Start Log Restores | Performs a transaction log restore on the secondary databases that belongs belong to this policy by running the corresponding job. This action applies to your previously defined policy settings. |
...
Detail | Description |
|---|---|
Icons | Indicate whether primary and secondary databases remain compliant with the backup and restore schedules defined by the policy. When compliant, the database icons are marked with a green check and the arrow icons pointing from database to database are green. |
State | Indicates whether the database is online or off-line, as well as whether the database is read-only. |
Last Backup | Displays the date and time when the last successful backup was performed. This detail displays only for the primary database only. |
Last Restore | Displays the date and time when the last successful restore was performed. This detail displays for each secondary database. |
Latency | Latency measures the amount of time that has elapsed since the last successful restore operation. |
Threshold (primary database) | Indicates how much time can elapse before a scheduled backup is considered missed. When a backup is missed, the policy status is non-compliant. You can change the threshold setting by editing your log shipping policy. |
Threshold (secondary database) | Indicates how much time can elapse after the last successful restore operation before the database is considered stale. When the database becomes stale, the policy status is non-compliant. You can change the threshold setting by editing your log shipping policy. |
Schedule | Displays how often backups are performed on the primary database and how often restores are performed on the secondary databases. |
...