Solved

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

Posted on 2009-07-02
9
229 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
  • 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
 

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
Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

 
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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

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…
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

895 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

16 Experts available now in Live!

Get 1:1 Help Now