• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3090
  • Last Modified:

Create Maintenance plans in SQL Server 2005

I cant create maintenance plans in SQL Server 2005. I can se the Mainteance plans folder in SQL Server Management Server Studio Express / Object Explorer. But when i right click to create a new maintenance plan I just see Reports

I have installed SSIS
1 Solution
sql 2005 express does not include the sql agent, so you won't be able to use the built-in maintenance snap-in. but you can use stored procedures to accomplish much of the same thing. have a look at

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now