Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2009-07-02
9
Medium Priority
?
237 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
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 

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 2000 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

I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
Loops Section Overview
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …

610 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