This project has moved and is read-only. For the latest updates, please go here.

Previous Configure Policy Based Management Configure Standard Database Properties Next

Configure Generic Maintenance Processes

All database maintenance can be performed by the SQL Generic Maintenance processes.

The SQL Generic Maintenance procedures use Ola Hallengren's Database Maintenance procedures for many tasks. Other maintenance processses use procedures that have been developed for SQL FineBuild.

For FineBuild v3.3.0, Database backup, Integrity check and Index maintenance are performed using the 19 July 2015 version of Ola's MaintenanceSolution.sql. For FineBuild v3.3.1, Database backup, Integrity check and Index maintenance are performed using the 7 Oct 2016 version of Ola's MaintenanceSolution.sql. If you want to use a more recent version of this file then download it from http://ola.hallengren.com/downloads.html and put it into the Additional Components folder.

FineBuild Database Maintenance Processes configuration

The Generic Maintenance Processes configuration relates to Process Id 5EF and is controlled by the parameters below:
Install Parameter Build SQL2005 SQL2008 SQL2008 R2 SQL2012 SQL2014 SQL2016 SQL2017
SetupGenMaint FULL Yes Yes Yes Yes Yes Yes Yes
SetupGenMaint WORKSTATION Yes Yes Yes Yes Yes Yes Yes
SetupGenMaint CLIENT N/A N/A N/A N/A N/A N/A N/A

In order to maintain compatibility with older versions of SQL FineBuild, the parameter ConfigGenMaint can also be used.

If SQL Server Express Edition is being installed, the maintenance processes will be set up as Windows Scheduled Tasks, because Express Edition does not include SQL Agent. For all other editions the maintenance processes are set up as SQL Agent Jobs. A core set of maintenance processes is always installed, but the advanced processes can not be installed for Express Edition.

A list of the maintenance processes is shown below:
Item Express Edition Other Editions Schedule
Backup DB - All - Full Windows Task N/A Daily at 21:00
Backup DB database name N/A Agent Job Daily at 21:00
Backup DB - All - Differential Windows Task Agent Job Daily at 07:00
Backup Log - All Databases Windows Task Agent Job Hourly, 1 minute past
Backup Log Alert N/A Agent Job Triggered by an Alert
DB database name: Corruption N/A Agent Job Trigered by an Alert
Index Optimise - System Databases Windows Task Agent Job Saturday at 18:00
Index Optimise - User Databases Windows Task Agent Job Saturday at 18:00
Integrity Check - System Databases Windows Task Agent Job Daily at 05:00
Integrity Check - User Databases Windows Task Agent Job Daily at 05:00
Set DB Space Used Windows Task Agent Job Saturday at 06:00
Set DB Maintenance Windows Task Agent Job Saturday at 06:00
Set DB Options Windows Task Agent Job Saturday at 06:00
Cleanup Backup History Windows Task Agent Job Daily at 08:00
Cleanup CommandLog Windows Task Agent Job Daily at 00:01
Cleanup Job History N/A Agent Job Daily at 08:00
Cleanup Output File Windows Task Agent Job Daily at 00:01

The Set DB Maintenance process creates any missing database backup jobs and database corruption alerts. It is scheduled to run every Saturday, but can also be run manually at any time to create the backup job for a new database.

After all processes have been created, review the scheduled run times so they meet your requirements. Except for Express Edition Full Backup jobs are created for each database, and it can be worth adjusting the schedules of these so that only about 4 jobs run at the same time in order to avoid saturating memory or disk IO.

Copyright FineBuild Team © 2013 - 2016. License and Acknowledgements
Previous Configure Policy Based Management Top Configure Standard Database Properties Next

Last edited Dec 16, 2016 at 3:52 PM by EdVassie, version 10