OlaHallengren

Get-DbaMaintenanceSolutionLog

Klaas Vandenberghe (@powerdbaklaas) | Simone Bizzotto (@niphlod)

Get-DbaMaintenanceSolutionLog View Source Klaas Vandenberghe (@powerdbaklaas) , Simone Bizzotto (@niphlod) Windows, Linux, macOS Synopsis Parses IndexOptimize text log files from Ola Hallengren’s MaintenanceSolution when database logging is disabled. Description Retrieves detailed execution information from IndexOptimize text log files when LogToTable=‘N’ is configured in Ola Hallengren’s MaintenanceSolution. This function parses the text files written to the SQL Server instance’s log directory, extracting index operation details including start times, duration, fragmentation levels, and any errors encountered.

Install-DbaMaintenanceSolution

Viorel Ciucu, cviorel.com

Install-DbaMaintenanceSolution View Source Viorel Ciucu, cviorel.com Windows, Linux, macOS Synopsis Installs Ola Hallengren’s Maintenance Solution stored procedures and optional SQL Agent jobs for automated database maintenance Description Deploys Ola Hallengren’s comprehensive maintenance framework including DatabaseBackup, DatabaseIntegrityCheck, IndexOptimize, and CommandExecute stored procedures to automate backup, DBCC checks, and index maintenance tasks. Optionally creates pre-configured SQL Agent jobs with intelligent scheduling for daily, weekly, and log backup routines. Replaces manual maintenance scripting with industry-standard procedures used by thousands of SQL Server environments worldwide.

Update-DbaMaintenanceSolution

Andreas Jordan, @JordanOrdix

Update-DbaMaintenanceSolution View Source Andreas Jordan, @JordanOrdix Windows, Linux, macOS Synopsis Updates existing Ola Hallengren Maintenance Solution stored procedures to the latest version Description Updates the stored procedures for Ola Hallengren’s Maintenance Solution on SQL Server instances where it’s already installed. This function downloads the latest version from GitHub and replaces only the procedure code, leaving all existing tables, jobs, and configurations intact. Use this when you need to get bug fixes or improvements in the maintenance procedures without disrupting your existing backup, integrity check, and index optimization jobs.