Backup and restore procedures

This worksheet is helpful for a general survey of your backup and restore procedures.

Task

Yes/No

Comments

Are backup and recovery procedures documented?

 

Are automated dump procedures in place?

 

What is the number of generations of dumps?

 

Are dumps kept off site?  

 

Are maintenance activities documented?

 

What is the frequency of Adaptive Server error log scanning?

 

Is database space utilization  monitored?

Has database capacity planning been performed recently?