Forum Discussion
Trying to create a SQL maintenance plan
I'm trying to create a SQL maintenance plan and I get this error message, please help:
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
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