Running a backup with no errors is good, but if you are missing an added drive or database when it’s critically needed you may not recover from a disaster.
When was the last time you reviewed your selection lists?
This should be done annually, if not more frequently, and after major upgrades have happened.
Things to consider:
- As a cross check, it would be best if it is done by a different person than the person who normally does the day-to-day backup tasks.
- The resources being backed up can be complex so you may need quite a few line items. It is probably best to track them in a spreadsheet or table to make it easier to compare the next time you review it.
- Since best practice for most backups is to run separate jobs for applications like SQL and Exchange it is common to have 2 or 3 jobs per database server.
- If you also track the amount of data that is backed up by each job and the time that takes, it gives you another point to compare growth and lets you watch for unexpected changes in data size or performance.
- You should confirm that the backups that are offsite are enough to let you come back from a total loss. Review your recovery time and recovery point objectives to make sure you will have what you need when you need it.
Don’t forget to encrypt your backups that will go offsite!
If you would like a review of your backup environment and procedures contact Peters & Associates and we would be happy to help. Email firstname.lastname@example.org or call us at 630.832.0075.