SQL Server Maintenance Solution

Downloads

Download MaintenanceSolution.sql. This script creates all the objects and jobs that you need.

You can also download the objects as separate scripts:

Note that you always need CommandExecute; DatabaseBackup, DatabaseIntegrityCheck, and IndexOptimize are using it.

When you update DatabaseBackup, DatabaseIntegrityCheck, or IndexOptimize you should also update CommandExecute.

You need CommandLog if you are going to use the option to log commands to a table.

Supported versions: SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, SQL Server 2019, SQL Server 2022, Azure SQL Database, and Azure SQL Managed Instance.

You can download the last version of the SQL Server Maintenance Solution that runs on SQL Server 2005 here.

The SQL Server Maintenance Solution is available on GitHub.

Script to check version timestamps: VersionCheck.sql

Sign up for the newsletter to be alerted about updates to the solution.