Solved

Maintenance sub-plans not available in SQL 2005

Posted on 2011-03-12
7
519 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
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
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

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

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

If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…

628 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