I have had the misfortune of inheriting the job of monitoring Backups for our small network of servers without any training or knowledge on the subject at all prior to.
We have version 9.1 REv 4691. with 4 jobs on the schedule, 2 FULL backups run weekly, 1 SQL DB backup run weekly, and 1 exchange backup that is currently on hold. probably because it was failing every time it ran - and after research I found that you shouldn't run it between midnite and 5am. :) so I'm fairly certain I can get a grip on this. My issues are these:
1. DATABASE MAINTENANCE FAILURE occurs EVERY time the backups run.(Job: "Database Maintenance") Summary of data base maintenance activity: * Performed database consistency check for BEDB database Maintenance has failed: 11, Check database failed Total elapsed time: 00:00:34
2. the drive that the backups are saved on, is COMPLETELY FRAGGED and I would like to think that you want some semblance of order in your backups? correct?
Can I get some suggestions please from the experts and the peanut gallery regarding the best approach to the Defrag as well as the database maintenance failure?
Thanks so much!