Page History
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.
What options are available for creating a log shipping policy?
When you create a log shipping policy, you can choose between the two following actions:
- Create Backup and Restore Jobs using the SQL Server Agent
- Create Backup and Restore Jobs using the SQL Safe Backup Agent
How does SQL Safe determine that a log shipping policy is okay?
SQL Safe determines that the policy is okay 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 SQL Safe determines a missed backup by changing these options:
...