Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Maintenance sub-plans not available in SQL 2005

Posted on 2011-03-12
7
Medium Priority
?
521 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 2000 total points
ID: 35122844
You go here and then create or modify a Maint plan.
 Maint Plan
Then you should have the toolbar.
0
What Is Blockchain Technology?

Blockchain is a technology that underpins the success of Bitcoin and other digital currencies, but it has uses far beyond finance. Learn how blockchain works and why it is proving disruptive to other areas of IT.

 
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

10 Questions to Ask when Buying Backup Software

Choosing the right backup solution for your organization can be a daunting task. To make the selection process easier, ask solution providers these 10 key questions.

Question has a verified solution.

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

When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
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…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

722 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