Learning from error messages is one of the best ways to gain knowledge and experience in SQL Server. Recently, one of my readers encountered an issue where the Maintenance Plan folder was missing under Management in SQL Server Management Studio. In this blog post, we will explore the possible reasons for this issue and how to resolve it.
The reader had installed SQL Server 2016 for their third-party software and wanted to ensure regular backups for their financial data. They came across the concept of maintenance plans and tried to create one, but couldn’t find the Maintenance Plan folder. They attempted to repair both the management studio and SQL Server engine, but to no avail.
Upon further investigation, I asked the reader for a complete snapshot of the object explorer and the output of the SELECT @@version query. It turned out that they were using the Express edition of SQL Server 2016. This edition does not include SQL Agent, which is responsible for scheduling maintenance plans. Therefore, the absence of the Maintenance Plan folder was expected.
Based on this scenario, there are two possible reasons for the missing Maintenance Plan folder:
- The logged-in account does not have sysadmin permissions. You can check this by running the query:
SELECT IS_SRVROLEMEMBER('sysadmin'). If it returns 0, the account does not have sysadmin permissions. - The SQL Server edition is Express. You can verify this by executing the query:
SELECT SERVERPROPERTY('Edition'). If it returns “Express Edition,” then the edition does not include SQL Agent and, consequently, the Maintenance Plan folder.
If you are facing a similar issue with the Maintenance Plan folder missing in SQL Server Management Studio, make sure to check these two factors. If neither of them applies to your situation, please share your experience in the comments section below.
Learning from each other’s experiences is invaluable in the SQL Server community. By sharing our knowledge, we can collectively enhance our understanding of SQL Server Management Studio and its various features.
Thank you for reading, and I hope this blog post has been helpful in resolving the issue of the missing Maintenance Plan folder in SQL Server Management Studio.