Cannot see Maintenance Plan option under Management on SQL 2005 Express

• LiftHigher

  Valued Member

  Points: 67

  More actions

  July 23, 2010 at 11:53 am

  #224472

  Hello,

  I have SQL Server 2005 Express edition on Windows Vista and for some reason I can't view the Maintenance Plan option.

  I have searched on-line and found several topics about this that suggested I added the user into the sysadmin role.

  I don't know how many times I have tried but I can't seem to find it. Initially I thought I missed something during installation so I uninstalled and installed it several times. I'm new at this and I'll try any advice you can give me.

  Thank you.

• Jeffrey Williams

  SSC Guru

  Points: 90342

  More actions

  July 26, 2010 at 1:37 pm

  #1198418

  Maintenance plans are not available in the Express Edition - which also does not have SQL Server Agent.

  You have two options:

  1) Upgrade to an edition that supports maintenance plans and SQL Server Agent

  2) Use Task Scheduler and scripts to manage your backups.

  Jeffrey Williams
  “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

  ― Charles R. Swindoll

  How to post questions to get better answers faster
  Managing Transaction Logs

• tanehome

  Ten Centuries

  Points: 1167

  More actions

  October 10, 2011 at 6:14 am

  #1392360

  i have the same problem and when I have tried to upgrade it givs me a message said that the sql agent is already installed, anybody can help????????????