Solved

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

Posted on 2009-07-02
9
234 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
Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

 

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

Enroll in June's Course of the Month

June's Course of the Month is now available! Every 10 seconds, a consumer gets hit with ransomware. Refresh your knowledge of ransomware best practices by enrolling in this month's complimentary course for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

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

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.
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…
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
This video Micro Tutorial shows how to password-protect PDF files with free software. Many software products can do this, such as Adobe Acrobat (but not Adobe Reader), Nuance PaperPort, and Nuance Power PDF, but they are not free products. This vide…

728 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