Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Is it possible to view the maintenance plans created in SQL Server 2000 (also running on the same SQL server 2000) in SQL 2005 Server Manangement Studio? I have the server added in my SSMS, but when I expand the Management folder, I don't see the Maintenance Plans folder like what I'd expect from a 2005 server.

For example, we have an optimization plan scheduled to run every week in SQL Server Agent and the command used to run this is: xp_sqlmaint N'-PlanID F7491D04-CDBA-496F-AE57-C2C5A3E3C8F8 (plus a bunch of options). I have no idea how to view this!

share|improve this question
up vote 2 down vote accepted

SQL 2000 maintenance plans are just SQL Jobs with a bunch of parameters. You can easily enough just look at the parameters which are passed to sqlmaint.

share|improve this answer
Thanks, mrdenny. Found the MSDN page for sqlmaint with its bunch of switches. By the way, big fan of your blogs! – deutschZuid Mar 12 '12 at 20:06

Figured it out. It's under Legacy->Database Maintenance Plans. Also all the plans, optimizations, integrity, trans log and complete backup are bunched up under one title.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.