Forum Discussion

David Shephard's avatar
David Shephard
Copper Contributor
Feb 21, 2024

Trying to create a SQL maintenance plan

I'm trying to create a SQL maintenance plan and I get this error message, please help:

 

 

  • Frank_AndersenDK's avatar
    Frank_AndersenDK
    Copper Contributor
    Feb 23, 2024
    Is SQL Server Integration Services (SSIS) installed on the server? To my knowledge, the built-in maintenance plans use SQL Server Integration Services behind the scenes.

    However, I would strongly suggest taking a look at Ola Hallengren's maintenance solution at https://ola.hallengren.com/. It's much more flexible than the standard Maintenance Plans and is free to use. 🙂

    It's been more than 10 years since I last configured maintenance plans—I've been using Ola Hallengren's solution ever since I discovered it.

    Regards,
    Frank

Resources