Sunday 6 March 2016

What are the recommendations to design a backup and recovery solution?

I hope the below recommendations will help you to design a backup and recovery solution.

  1. Determine what is needed
  2. Recovery Model
  3. Select Backup Types
  4. Backup Schedule
  5. Backup Process
  6. Document
  7. Backup to Disk
  8. Archive to Tape
  9. Backup to Different Drives
  10. Secure Backup Files
  11. Encrypt or Password Protect Backup Files
  12. Compress Backup Files
  13. How Much to Keep on Disk
  14. Online Backups
  15. Run Restore Verifyonly
  16. Offsite Storage
  17. Additional information:
  18. SQL Server Backup Checklist
Please comment if you have more recommendations to design a backup and recovery solution.  Jainendra Verma


No comments:

Post a Comment