Download MaintenanceSolution.sql. This script creates all the objects and jobs that you need.
You can also download the objects as separate scripts:
- DatabaseBackup: SQL Server Backup
- DatabaseIntegrityCheck: SQL Server Integrity Check
- IndexOptimize: SQL Server Index and Statistics Maintenance
- CommandExecute: Stored procedure to execute and log commands
- CommandLog: Table to log commands
Note that you always need CommandExecute; DatabaseBackup, DatabaseIntegrityCheck, and IndexOptimize are using it. You need CommandLog if you are going to use the option to log commands to a table.
Supported versions: SQL Server 2017, SQL Server 2019, SQL Server 2022, SQL Server 2025, Azure SQL Database, and Azure SQL Managed Instance
- Backup: https://ola.hallengren.com/sql-server-backup.html
- Integrity Check: https://ola.hallengren.com/sql-server-integrity-check.html
- Index and Statistics Maintenance: https://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html