How to create a maintenance plan in SQL Server Management Studio Express

Tags:
Microsoft SQL Server Management Studio
MSSMSE
SQL Server 2005
SQL Server Express Edition
I’m running SQL Server 2005 Workgroup edition with SP2. I’m trying to create a new Maintenance Plan in Microsoft SQL Server Management Studio Express (MSSMSE) by right clicking on the Maintenance Plans object icon. The only option is Refresh - there’s no manual method or wizard. I'm logging in as sa and my server role is sysadmin. I had already changed the authentication as mixed. I’ve seen lots of posts and they all say I simply need to have the sysadmin server role. But there must be something else, maybe services that need to be running?

Answer Wiki

Thanks. We'll let you know when a new response is added.

SQL Server Express edition doesn’t support maintenance plans as using the maintenance plans requires have Integration Services installed. As Express edition doesn’t include Integration Services you can not create a maintenance plan. To rebuild the indexes you will need to write scripts to handle the work, then run then from a scheduler.

As the Express edition also doesn’t include the SQL Agent I usually recommend using the Windows Task Scheduler to run SQL Agent jobs.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • ChristianBahnsen
    I thought express doesn't support sql agent jobs. Are you saying you can create jobs, store them outside ssms (if yes, where should they be stored?), and run them as scheduled tasks? Thanks.
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following