July 23, 2010 at 11:53 am
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.
July 26, 2010 at 1:37 pm
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
October 10, 2011 at 6:14 am
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????????????
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply