Sql Server 2014-Maintenance Plan

Question

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

Answer 1

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.

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')  

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.