Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  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.



Scroll pdf ignore
SQL Safe Backup hands-free backup and instant recovery across your SQL Servers.
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
 | 
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
 
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
 | 
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
 | 
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
 
|
 
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
 | 
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
 
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse