Database maintenance settings > Maintenance policy templates > Policy for large OLTP databases with intensive data input |
A maintenance policy template for large databases with intensive data input during the day.
Recovery model: Full
The policy includes three QMB Jobs:
1. CPU-intensive tasks (once a week) for large OLTP databases
Schedule: once a week on Monday at 1 AM
Tasks:
Email notifications: Every time after QMB Job completion
2. CPU-intensive tasks (every night) for large OLTP databases
Schedule: every night at 1 AM except Monday
Tasks:
Email notifications: In case of errors
3. Log backup (during the workday)
Schedule: every day from 8 AM till 11 PM, every 30 minutes
Tasks:
Email notifications: In case of errors