Maintenance plans help you automate routine database maintenance tasks, such as backing up databases, updating statistics, and rebuilding indexes to run on a specific day and time. This ensures that your databases are stable and perform at optimal levels.
4.x maintenance plans are considered legacy plans.
In SQL Server 2005 or later, maintenance plans create SSIS packages that run as agent jobs.
To take advantage of Integration Services (SSIS) in maintenance plans, Integration Services must be installed on any server instance where you want to create maintenance plans. Integration Services may be a part of the Client Tools or a part of SQL Server.
You can manage both native SQL Server and LiteSpeed maintenance plans
You need to have LiteSpeed installed on every server instance where you want to create LiteSpeed maintenance plans. Otherwise, only native SQL Server functionality is available.
You can convert native SQL Server maintenance plans to LiteSpeed maintenance plans. Using this option, you can also convert previous LiteSpeed maintenance plans to the latest version. Upgrade LiteSpeed Maintenance Plans
To convert a maintenance plan