Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 534
  • Last Modified:

Maintenance sub-plans not available in SQL 2005

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
AndrewW5
Asked:
AndrewW5
  • 4
  • 3
1 Solution
 
Jim P.Commented:
Is the highlighted area greyed out?
EE-Q-26882170.png
0
 
AndrewW5Author Commented:
That toolbar / highlighted area doesn't exist. I wondered if it was a view option I can't figure out?
0
 
Jim P.Commented:
You go here and then create or modify a Maint plan.
 Maint Plan
Then you should have the toolbar.
0
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!

 
AndrewW5Author Commented:
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
 
AndrewW5Author Commented:
mission = missing
0
 
Jim P.Commented:
That is weird.  Maybe try reinstalling the studio.
0
 
AndrewW5Author Commented:
I won't be able to reinstall until late next week.  I'll report back.
0

Featured Post

Technology Partners: 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!

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