• DBA

    Setup Ola Hallengren SQL server Maintenance script

    Ola Hallengren Maintenance Plan Deployment Many of DBAs already started using the Ola hallengren’s maintenance plan script. It is a free script replacing traditional GUI maintenance plan. It is very good script for all type and variety of database, application and size. He is a Microsoft award winner for his maintenance plan script. Here is the steps, how to use effectively for many servers. You can use a CMS if you registered it or one be one. Job and SP creation https://ola.hallengren.com/downloads.html — You can download all in one-shot or needed one. Create a dedicated DB called DBA_DB or by default it uses master DB and run the downloaded script USE [master]…