Quick Maintenance & Backup for MS SQL
Policy for small or medium-sized OLTP databases with intensive data input
| Database maintenance settings > Maintenance policy templates > Policy for small or medium-sized OLTP databases with intensive data input |
A maintenance policy template for small databases with intensive data input throughout the day.
Recovery model: Full
The policy includes three QMB Jobs:
1. CPU intensive tasks for mid-sized OLTP databases (once a week)
Schedule: once a week on Monday at 1:00 AM
Tasks:
Email notifications: Every time after a QMB Job is completed
2. CPU intensive tasks for mid-sized OLTP databases (every night)
Schedule: every night at 1 AM except Monday
Tasks:
Email notification: In case of errors
3. Log backup and modified statistics updates (during the workday)
Schedule: every day from 8 AM till 23 PM, every 30 minutes
Tasks:
Email notification: In case of errors