You can use the SQL Safe log shipping, backup, and restore policies to automate and enforce your disaster recovery requirements or Service Level Agreements (SLAs).

SQL Safe no longer provides the Maintenance Plan Conversion Utility.

How to use log shipping policies as maintenance plans

Use the following steps to create a new log shipping policy based on an existing SQL Server Log Shipping maintenance plan.

To create a log shipping policy based on a maintenance plan:

  1. Use SQL Server Management Studio to connect to the SQL Server instances for which you have a native maintenance plan.
  2. Disable the backup jobs associated with the primary instance.
  3. Allow all restore jobs associated with the secondary instances to complete, and then disable these jobs.
  4. Start the SQL Safe Management Console, and start the Log Shipping Policy Wizard.
  5. On each wizard window, specify the appropriate options, and then click Finish. Because the selected instances were previously included in a native maintenance plan, you do not need to initialize the secondary instances.
  6. Test your new log shipping policy by tracking the policy status.
  7. Delete your native maintenance plan.

How to use backup policies as maintenance plans

Use the following steps to create a new backup policy based on an existing SQL Server maintenance plan.

To create a backup policy based on a maintenance plan:

  1. Use SQL Server Management Studio to connect to the SQL Server instances for which you have a native maintenance plan.
  2. Disable the backup jobs associated with this plan.
  3. Start the SQL Safe Management Console, and start the Backup Policy Wizard.
  4. On each wizard window, specify the appropriate options, and then click Finish.
  5. Test your new backup policy by tracking the policy status.
  6. Open your maintenance plan and delete the tasks that performed your backups, and then enable the appropriate jobs associated with this plan. If your maintenance plan performed backups only, delete your native maintenance plan.

How to use restore policies as maintenance plans

Use the following steps to create a new restore policy based on an existing SQL Server maintenance plan.

  1. Create a backup policy that archives the databases you want to routinely restore.
  2. Test your backup policy by running the policy jobs. This action also creates source backup files for your new restore policy.
  3. Use SQL Server Management Studio to connect to the SQL Server instances that have a native maintenance plan you want to replace.
  4. Disable the backup and restore jobs associated with this plan.
  5. Start the SQL Safe Management Console, and start the Restore Policy Wizard.
  6. On each wizard window, specify the appropriate options, and then click Finish.
  7. Test your new restore policy by tracking the policy status.
  8. Open your maintenance plan and delete the tasks that performed your backups and restores, and then enable the appropriate jobs associated with this plan. If your maintenance plan performed backups and restores only, delete your native maintenance plan.



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