Take the 2-minute tour ×
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. It's 100% free, no registration required.

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
add comment

2 Answers 2

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
add comment

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
add comment

Your Answer

 
discard

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.