Sql Server 2014-Maintenance Plan

mby 106 Reputation points
2021-01-28T14:38:12.397+00:00

Hello,

How can i add Maintenance Plan in Sql Server 2014?
I add Management Tools in the Feature Selection and it still does not appear
Thanks

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
532 questions
{count} votes

Accepted answer
  1. CathyJi-MSFT 22,201 Reputation points Microsoft Vendor
    2021-01-29T03:16:19.943+00:00

    Hi @mby ,

    Did you mean Maintenance Plan Folder missing under Management Folder in SQL Server Management Studio? Please using select @@version to check your SQL server edition and share us the output of it. SQL server Express edition has no SQL server agent service, so there is no maintenance plan folder in SSMS.

    61639-screenshot-2021-01-29-112208.jpg

    61657-screenshot-2021-01-29-113023.jpg

    Please using below query to check if logged in account having sysadmin permissions. If the result is 0, then you login do not have sysadmin permissions, there is also no maintenance plan folder in SSMS.

    SELECT IS_SRVROLEMEMBER('sysadmin')  
    

    61640-screenshot-2021-01-29-113428.jpg61691-screenshot-2021-01-29-113408.jpg
    If I misunderstood your issue, please let me know.

    If you want to create a maintenance plan, please refer to MS document Create a Maintenance Plan to get more.

    Best regards,
    Cathy


    If the response is helpful, please click "Accept Answer" and upvote it, thank you.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.