Quick Maintenance & Backup for MS SQL
Policy for large databases with a minor data modification rate (based on Ola Hallengren script)

A maintenance policy template for large databases with minor modifications throughout 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: Simple

The policy includes two QMB Jobs:

1. CPU-intensive tasks (once a week)

2. Differential backup and system database maintenance (every night)

The user can change any parameters of a maintenance policy, add new QMB Jobs and tasks. 


See Also

General Information

User interface