Quick Maintenance & Backup for MS SQL
Policy for archive databases and data warehouses with occasional updates
| Database maintenance settings > Maintenance policy templates > Policy for archive databases and data warehouses with occasional updates |
A maintenance policy template for database backups and various storages with occasional data updates during the week.
Recovery model: Simple
The policy includes two QMB Jobs:
1. CPU-intensive tasks for database backups and data warehouses (once a week)
Schedule: once a week on Monday at 1 AM
Tasks:
Email notifications: every time upon the completion of a QMB Job
2. Differential backup and system database maintenance (every Wednesday)
Schedule: every Wednesday at 01:00 AM
Tasks:
Email notifications: in case of errors