question

zahid 1 avatar image
zahid 1 asked

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

Hi, 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
sql-server-2008-r2maintenance-plans
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image
ThomasRushton answered
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
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Adiga avatar image
Adiga answered
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
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.