asked on

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

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?

Aneesh

SQL Server express wont support this feature

brian-barnett

ASKER

What are my options then? What management console should I use and where can I download it?

Aneesh

make the query for whatever you are supposed to do with the maintenace wizard and use sqcmd + windows sceduler;

brian-barnett

ASKER

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.

Aneesh

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

brian-barnett

ASKER

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.

ASKER CERTIFIED SOLUTION

Aneesh

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Aneesh

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

brian-barnett

ASKER

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.