Maintenance Plan in SQL Server 2008R2 Express edition with advance feature


Can any body confirm me that is Maintainance Plan in "SQL Server 2008R2 Express Edition with Advance Feature" are available? how can i get it free ?

Thanks in advance
more ▼

asked Aug 28, 2010 at 01:21 PM in Default

zahid 1 gravatar image

zahid 1
1 1 1 1

(comments are locked)
10|1200 characters needed characters left

2 answers: sort newest

For maintenance plans to execute, SQL Agent needs to be running. Even though SQL Server 2008 R2 installs SQL Agent, one cannot start it. Please refer [this][1] for more information.

[1]: http://jmkehayias.blogspot.com/2009/01/sql-server-2008-express-sql-agent-won.html
more ▼

answered Aug 29, 2010 at 03:53 AM

Adiga gravatar image

221 1

(comments are locked)
10|1200 characters needed characters left

Hi. Judging by [MS's documentation on SQL Server 2008 Express][1], it appears that the Advanced Services option provides SSRS and Full Text Search. No mention of Maintenance Plans, sorry.

[1]: http://www.microsoft.com/sqlserver/2008/en/us/express.aspx
more ▼

answered Aug 28, 2010 at 01:50 PM

ThomasRushton gravatar image

ThomasRushton ♦
34.2k 18 20 44

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Aug 28, 2010 at 01:21 PM

Seen: 8482 times

Last Updated: Aug 28, 2010 at 01:51 PM