Database Backups Maintenance Tips

Database backup is a critical maintenance operation. All operators should periodically check for appropriate frequency of backup, duration of backup and any errors in database backup.

Frequency: Examine the Crontab to make sure the Primary NMS is backed up to the Backup NMS once daily.

Duration: Examine backup log and cons.output to make sure Backups are complete within 30 minutes. (This can take longer for networks large number of remotes.) Also make sure the timings of Consolidation and Backup scripts do not overlap. The latest Consolidator log should finish before the most recent backup starts. Otherwise, consider altering the database backup time in crontab so that the database backup starts after the consolidation finishes.

Errors: Check to make sure no errors are recorded in the cons.output and dbbackup.output files.

Leave a Reply

Your email address will not be published. Required fields are marked *