Quick Maintenance & Backup for MS SQL
Policy for small or middle-sized OLTP databases with intensive data input (based on Ola Hallengren script)
| Database maintenance settings > Maintenance policy templates > Policy for small or middle-sized OLTP databases with intensive data input (based on Ola Hallengren script) |
A maintenance policy template for small databases with intensive data input during the day.
Template QMB Jobs use tasks that invoke Ola Hallengren stored procedures (read more at https://ola.hallengren.com/). Stored procedures are installed by the wizard prior to the creation of a maintenance policy on the service procedures execution stage. Stored procedures can also be reinstalled by running the Install the Ola Hallengren solution from the context menu of the list of servers and policies. |
Ola Hallengren stored procedures work with any SQL server version starting from 2005. This version of the program contains stored procedures from 25.01.2015. |
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 AM
Tasks:
Email notifications: every time after the completion of a QMB Job
2. CPU intensive tasks for mid-sized OLTP databases (every night)
Schedule: every night at 1 AM except Monday
Tasks:
Email notifications: In case of errors
3. Log backup and modified statistics updates (during the workday)
Schedule: every day from 8 AM till 11 PM every hour
Tasks:
Email notifications: In case of errors