Maintenance Plans with Ola Hallengren’s Free Scripts - Troy Gallant


Today’s SQL Server DBA has a myriad of options when it comes to implementing their backup and maintenance strategies. From internal maintenance plans to all-encompassing third-party solutions, the options are practically endless. One very popular solution revolves around a set of free scripts provided by Swedish data scientist, Ola Hallengren. These well admired scripts are used by corporations large and small worldwide in order to facilitate backups, integrity checks, and index maintenance operations.

In this session, not only will we introduce these scripts to those unfamiliar with them, but just as importantly, we’ll take a detailed look into just how these scripts can be extended and customized even further. You’ll be amazed at the flexibility offered by the optional parameters. We’ll also take a gander into the remarkably detailed logging tables in order to inspect the raw data and possibly turn it into a valuable reporting data source.


Troy Gallant has been a SQL Server professional for over 19 years; filling various roles as analyst, developer, and for the last decade and a half, DBA. As a regular speaker at SQL Saturdays up and down the east coast, he’s instructed on a multitude of topics from disaster recovery, to performance tuning, to professional development. Currently residing in Jacksonville once again and working in the finance industry, he recently spent two years as Sr. DBA for the EDW of a major international insurance company in New York City. Go Gators.