The SQL Safe Log Shipping Policy Wizard allows you to create log shipping maintenance plans across your enterprise. A SQL Safe log shipping policy is defined as a set of primary and secondary databases whose data is synchronized by shipping transaction log backups according to a defined schedule.

How do you access the Log Shipping Wizard?

You can access the Log Shipping Policy Wizard from any of the following paths:

  • Go to the task bar, click Create Policy and then choose Log Shipping Policy.
  • On the Policies tab, right-click the Log Shipping Policies folder and select Create Log Shipping Policy.
  • On the Policies tab, right-click one of your Log Shipping Policies and select Create Log Shipping Policy.
  • On the Policies tab, click Create New Policy located on the Operation Summary section of the Log Shipping Policies Status window. This option is only available before you create your first log shipping policy. 
  • From any tab, go to the File menu, select Create Policy and then Log Shipping Policy.

To get started with the Log Shipping Policy Wizard:

  1. Name the policy.
  2. Select the primary database that you want to back up.
  3. Specify where these transaction log files should be stored.
  4. Select the secondary database you want to synchronize with the primary.
  5. Get e-mail notifications about the policy status.
  6. Review details.



IDERA | Products | Purchase | Support | Community | Resources | About Us | Legal
  • No labels