I hope the below recommendations will help you to design a backup and recovery solution.
- Determine what is needed
- Recovery Model
- Select Backup Types
- Backup Schedule
- Backup Process
- Document
- Backup to Disk
- Archive to Tape
- Backup to Different Drives
- Secure Backup Files
- Encrypt or Password Protect Backup Files
- Compress Backup Files
- How Much to Keep on Disk
- Online Backups
- Run Restore Verifyonly
- Offsite Storage
- Additional information:
- 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