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, 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. 
  • On the Policies tab, right-click the Log Shipping Policies folder and select Create 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 backup options.
  5. Select the secondary database you want to synchronize with the primary.
  6. Get e-mail notifications about the policy status.

 

SQL Safe is a high-performance backup and recovery solution for your SQL Servers. Learn more > >
  • No labels