?
Solved

Cannot Create Maintenance Plan - SQL Server 2005

Posted on 2010-01-12
6
Medium Priority
?
495 Views
Last Modified: 2012-05-08
Hi All,

I'm a little stuck with SQL 2005.

I have installed it on our server, and separately downloaded SQL Server Management Studio Express.
When I right-click on Maintenance Plans, I only get the 'Refresh' option.

I believe I'm using the full version of SQL 2005 as I downloaded it from our Volume Licence Site at Microsoft.

If anyone can help me, it'd be much appreciated. I have attached a couple of images to show what's installed / running as services.

Many Thanks,

Pete
Capture.JPG
Capture2.JPG
0
Comment
Question by:PeterHing
  • 3
  • 3
6 Comments
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 26294544
the ssms- express edition wont support  the maintenance plan
0
 
LVL 2

Author Comment

by:PeterHing
ID: 26294827
So what would you suggest I do?
0
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 26294984
go for the SQL Server standard edition or use the third party tools
http://www.lazycoding.com/products.aspx
0
Industry Leaders: 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!

 
LVL 2

Author Comment

by:PeterHing
ID: 26295145
Thanks for your replies. Is there anything Microsoft has to offer? Or have the maintenance plan sections been removed?
0
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 26295350
not really, one option is to schedule it using the windows scheduler
0
 
LVL 2

Accepted Solution

by:
PeterHing earned 0 total points
ID: 26514149
The tools I was looking for were on the SQL 2005 CD. I just had the wrong Management Studio installed
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering 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

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…
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…

569 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