Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

No maintenance plan wizard? 1

Status
Not open for further replies.

bubarooni1

Technical User
Dec 18, 2007
51
US
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?


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

John
 
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...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top