A maintenance policy template for large databases with minor data changes throughout the day.
Recovery model: Simple
The policy includes two QMB Jobs:
1. CPU-intensive tasks (once a week)
Schedule: once a week on Monday at 1:00 AM
Tasks:
- Defragment and rebuild indexes
- Update modified statistics
- Database integrity check
- Delete old backup files
- Clear the backups history
- Full backup
- Restore backups to a temporary database with a subsequent integrity check. The task is disabled by default. Can be used for verifying the latest backup.
- System databases integrity сheck and backups
Email notification: every time upon the completion of a QMB Job
2. Differential backup and system database maintenance (every night)
Schedule: every night at 1 AM except Monday
Tasks:
- Differential backup
- Restore backups to a temporary database with a subsequent integrity check. The task is disabled by default. Can be used for verifying the full and the latest differential backups.
- System databases integrity сheck and backups
Email notification: in case of errors
The user can change any parameters of a maintenance policy, add new QMB Jobs and tasks.
See Also
General Information
User interface