2

Unable to find maintenance plans folder under management in sql server 2012

But executing this query finds maintenance plans in ssispackagefolder.

SELECT
  *
FROM
  dbo.sysssispackagefolders

An the result is

folder id                               parentfolderid                          folder name
08AA12D5-8F98-4DAB-A4FC-980B150A5DC8    00000000-0000-0000-0000-000000000000    Maintenance Plans
Pred
  • 8,789
  • 3
  • 26
  • 46
shubh
  • 61
  • 1
  • 3
  • 11

1 Answers1

3

Check whether your server is not the Express edition running following command:

select CASE WHEN @@version LIKE '%Express%' THEN 'Express' ELSE 'OK' END

Note that even on the SQL Server Express edition the Maintenance plans folder is present in dbo.sysssispackagefolders table.

On Express edition the Maintenance plans feature is not available because it does not include the SQL server agent. You must use another tool like Windows Taks Scheduler to schedule running backups etc., see e.g. here.

Community
  • 1
  • 1
Vojtěch Dohnal
  • 7,867
  • 3
  • 43
  • 105