The General tab of the Log Shipping Policy wizard allows you to specify the basic properties of the log shipping policy.
Why should you specify a name or description?
You are required to enter a unique name for each policy.
Both the name and description will appear in the status messages for your policies. Using a meaningful name and description will allow you to more easily identify problems when they occur. For example, consider specifying a description that will help you later choose the correct backup to restore during a disaster recovery situation.
How does SQLsafe determine that a log shipping policy is ok?
SQLsafe determines that the policy is ok by looking at the following statuses:
- Whether the transaction log backup on the primary database has completed on schedule
- Whether the transaction log restore on the secondary database has completed without warnings or errors
- Whether the data on the secondary database is stable
How do you control when a log shipping policy is compliant?
You can control how SQLsafe determines a missed backup by changing these options:
- Select a time limit for the log backup to occur. This is the leeway time allowed for the log backup to occur. If the log backup occurs within this period from the scheduled time, the policy is still compliant.
- Select an age limit for the secondary's data. This is the tolerance level for how old the data in the secondary database can be.