Solved

Maintenance sub-plans not available in SQL 2005

Posted on 2011-03-12
7
516 Views
Last Modified: 2012-05-12
Hello all,

I'm creating a maintenance plan for backup on a new (to us) SQL 2005 server. Typicailly, I create a plan with a few sub-plans.  Today I'm struggling with the absence of a sub-plan option.  I've googled this a number of ways, and all instructions assume that if you're in the maintenence plan object, sub-plans can be added.  Is there a option on SQL installs the sub-plans option?
0
Comment
Question by:AndrewW5
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 38

Expert Comment

by:Jim P.
ID: 35119264
Is the highlighted area greyed out?
EE-Q-26882170.png
0
 
LVL 4

Author Comment

by:AndrewW5
ID: 35122138
That toolbar / highlighted area doesn't exist. I wondered if it was a view option I can't figure out?
0
 
LVL 38

Accepted Solution

by:
Jim P. earned 500 total points
ID: 35122844
You go here and then create or modify a Maint plan.
 Maint Plan
Then you should have the toolbar.
0
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 
LVL 4

Author Comment

by:AndrewW5
ID: 35129274
Two screep caps.  Top, from a different server, looks like yours and works like I would expect.  Bottom is the problem server which is mission subplan option.  I feel like there is toolbar view or some other option we don't have checked. Screen shot
0
 
LVL 4

Author Comment

by:AndrewW5
ID: 35129282
mission = missing
0
 
LVL 38

Expert Comment

by:Jim P.
ID: 35133881
That is weird.  Maybe try reinstalling the studio.
0
 
LVL 4

Author Comment

by:AndrewW5
ID: 35168176
I won't be able to reinstall until late next week.  I'll report back.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question