SQL Server 2005 Maintenance wizard

  • I've created a maintenance plan thru a wizard and can't figure out how to see/edit the plan. In SQL Server 2000 there are multiple tabs showing all information. Is there any way to attach different schedules to db backup, tran log backup and so on ? It looks like the same schedule has to be used for all components of the plan. Thank you, Mike. 

  • Guys,

    I've already found a solution. You have to use Maintenance Toolbox (go to view, click on Toolbox). It looks very combersome, but it works. Thru graphical interface you can drug available objects and choose your options including a scheduler...

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply