Share via

SQL Server 2019 Maintenance Plan Tasks Toolbox Missing

John Robinson 26 Reputation points
2022-03-25T18:23:12.08+00:00

Unable to add tasks to new maintenance plan because there is no Maintenance Plan Toolbox. How can we create or recover this Toolbox? This is a new install of SQL 2019 and first time adding maintenance plan on this server.

187044-image.png

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,325 questions
Accepted answer
  1. Ronen Ariely 15,106 Reputation points
    2022-03-26T03:05:15.883+00:00

    OK, now I get your issue :-)

    Most important! I would recommend to stop using the maintenance wizard anyway and start using transact SQL queries.

    To solve the issue, First make sure you are using the latest version of SSMS

    Now, if this continue then try to reset the toolbox first: right click on the toolbox and select reset toolbox

    187065-image.png

    Is this solved your issue?

    If not then: Close the toolbox windows -> View -> Choose Toolbox to re-open the it -> Right click on the empty space and select "show all"

    Is this solve the issue?

    2 people found this answer helpful.

4 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ronen Ariely 15,106 Reputation points
    2022-03-25T18:47:07.727+00:00

    Good day and welcome to the QnA forums

    To create a Maintenance Plan all you need is the ability to execute queries (and the right permission on the server).

    I assume that your issue is not with SQL Server but a client application like the SQL Server Management Studio (also known as SSMS). I am guessing that you speak about using the SSNS Maintenance Plan Wizard

    Please follow the step-by-step instructions in this documentation:

    https://learn.microsoft.com/en-us/sql/relational-databases/maintenance-plans/create-a-maintenance-plan?view=sql-server-ver15&WT.mc_id=DP-MVP-5001699

  2. Olaf Helper 43,166 Reputation points
    2022-03-28T06:44:13.307+00:00

    To which version & edition of SQL Server are you connected to, using SSMS?
    The free Express Edition do not support SQL Server-Agent jobs nor maintenance plans nor any scheduled jobs.

    0 comments
  3. John Robinson 26 Reputation points
    2022-03-28T13:30:28.047+00:00

    Reinstalling SSMS with the current release fixed the missing maintenance toolbox issue.

    Thank you for helping me out with this solution! Now that this issue is resolved I will take your warning to heart and implement Ola Hallengren's SQL server maintenance solution. Ola's maintenance allows fine tuning that the SQL maintenance wizard does not provide. I started going down this path on Friday when I couldn't get the SQL plans to work.

    187612-image.png

    0 comments
  4. RUPERT EDANG 0 Reputation points
    2024-07-21T05:27:04.0533333+00:00

    Hi Everyone, accept greetings from my me.

    I'm currently running SQL 2019 but I do not see the Folder for Maintenance Plan.

    Please can someone help?

    User's image

    0 comments