Solved

SQLServer 2005 Maintenance Plans - no option to create a new one

Posted on 2009-07-02
9
232 Views
Last Modified: 2012-05-07
Recently installed SQLServer 2005. The Maintenance Plans section has no functionality. The only context menu item is "Refresh". When I highlight Maintenance Plans, the pane on the right is empty. Using Microsoft SQL Server Management Studio Express. What am I missing/doing wrong?
0
Comment
Question by:brian-barnett
[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
  • 5
  • 4
9 Comments
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 24768735
SQL Server express wont support this feature
0
 

Author Comment

by:brian-barnett
ID: 24768759
What are my options then? What management console should I use and where can I download it?
0
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 24768807
make the query for whatever you are supposed to do with the maintenace wizard and use  sqcmd + windows sceduler;
0
Backup Solution for AWS

Read about how CloudBerry Backup fully integrates your backups with Amazon S3 and Amazon Glacier to provide military-grade encryption and dramatically cut storage costs on any platform.

 

Author Comment

by:brian-barnett
ID: 24768842
I believe it can be done using Windows Scheduler, but I am not a database administrator, nor do we have access to one. I am a developer trying to do database stuff, network stuff, and programming stuff. I don't have time to learn a command line interface. I need a wizard with a super friendly and forgiving UI :) I'll look around for another option. I suspect there is a non "express" version I should download and use.
0
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 24768871
the other option is to installl a stadard/ enterprise edition of sql server, which allows this feature. This feature is strictly dependant on the sql server Engine and as i mentioned earlier, sql Express wont support this
0
 

Author Comment

by:brian-barnett
ID: 24768894
Are you saying that I do not have a standard/enterprise version of sql server then? How can I tell? I thought it was a standard version.
0
 
LVL 75

Accepted Solution

by:
Aneesh Retnakaran earned 500 total points
ID: 24768898
0
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 24768915
run this in a new query window, that will tell you the edition you are using

select SERVERPROPERTY('Edition')

if it is sql standard/ enterprise , make sure that SQL Server agent is running
0
 

Author Comment

by:brian-barnett
ID: 24768947
Ran select SERVERPROPERTY('Edition') and got:
Standard Edition (64-bit)

SQL Server Configuration Manager shows SQL Server Agent (MSSQLSERVER) running.

I think I will just use the expressmaint utility you pointed me to.
0

Featured Post

Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

Question has a verified solution.

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

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

726 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