Quick Maintenance & Backup for MS SQL
Maintenance policy templates

The first step of the maintenance policy creation wizard displays a list of 7 maintenance policy templates for different types of databases. 3 of them use Ola Hallengren scripts.

To create an empty policy, select the Create an empty maintenance policy option on the list.

Maintenance policies should include databases with similar characteristics: frequency and intensity of data input/modification, size, available database maintenance window. For example, if data are loaded into a database once a week, it shouldn’t be included in the same policy with databases with frequently backed up transaction logs and daily updated indexes, which is a sign of day-to-day intensive data input. Otherwise, it will result in excessive load on the SQL server and a large number of unnecessary backups, which, in turn, will increase the backup restoration time in case of database corruption.

The database recovery model defines the date to which the data will be restored to in case of an accident. For instance, the Full recovery model implies that the data can be restored virtually to the instant when the system crashed or any other preceding moment, given that there is a full backup and the necessary backups of the transaction log. When the Simple model is used, data can only be recovered to the date of the most recent backup. See more details https://msdn.microsoft.com/en-us/library/ms189275.aspx 

We recommend using the Full model for databases with daily data input.

By default, all templates include tasks for servicing system databases. Please bear in mind that the program creates several maintenance policies for one SQL server. In this case, after you create a second and subsequent policies, you should delete unnecessary database maintenance tasks from the QMB jobs.

Maintenance policies based on QMB Jobs

Maintenance policies based on Ola Hallengren stored procedures

Maintenance policy templates are not editable. The program supports copying of policies between SQL servers. This allows you to create a policy once and copy it afterwards.
See Also

Wizard steps

General Information