Solved

Maintenance sub-plans not available in SQL 2005

Posted on 2011-03-12
7
515 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
  • 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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
sql help 5 54
SQL Encryption question 2 62
tempdb log keep growing 7 34
Are triggers slow? 7 14
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 PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

828 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