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

asked Aug 28 '10 at 01:21 PM in Default

zahid 1
1 ● 1 ● 1 ● 1

(comments are locked)

2 answers:

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 for more information.

answered Aug 29 '10 at 03:53 AM

Adiga
221 ● 1

(comments are locked)

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

answered Aug 28 '10 at 01:50 PM

ThomasRushton ♦
29.4k ● 6 ● 9 ● 36