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:

...