Solved

Maintenance sub-plans not available in SQL 2005

Posted on 2011-03-12
7
512 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.
Need to grow your business through quality cloud solutions? With everything required to build a cloud platform and solution, you may feel like the distance between you and the cloud is quite long. Help is here. Spend some time learning about the Con…

930 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now