No maintenance plan wizard? 1

[bubarooni1]

Hi,

If I understand correctly, in SQL Server Management Studio Express I should be able to go to:

Object Explorer -> dbl click Management, right click Maintenance Plans and then start the Maintenance Plan Wizard.

When I get to the Management folder though, I only have SQL Server Logs and Activity Monitor.

Am I missing something here? Do I need to install something else to get this functionality?

 

[olahallengren]

Unfortunately SQL Server Express doesn't have the Maintenance Plans.

I have a set of maintenance stored procedures that you're welcome to use.

http://blog.ola.hallengren.com/blog/_archives/2008/1/1/3440068.html

Ola Hallengren

http://ola.hallengren.com

 

[JohnBates]

And Express also lacks a job scheduler (Agent). So you would not be able to schedule an execution of a maint plan.

John

 

[bubarooni1]

Hey Ola,

Thanks for the link! It looks pretty complicated and may be outside my abilities to implement, I honestly don't know how to go about it. Nonetheless, I'm gonna upgrade the db to SP2 and give it a shot...

 

[olahallengren]

It's not so complicated. Please contact me if you need any help.

http://blog.ola.hallengren.com/About.html

Ola Hallengren

http://ola.hallengren.com