September 2010
Intermediate to advanced
1704 pages
111h 8m
English
You can create or modify maintenance plans in SQL Server 2008 without using the Maintenance Plan Wizard. To create a new maintenance plan without the wizard, you right-click the Maintenance Plan node in the Object Explorer and select New Maintenance Plan. You are prompted for a maintenance plan name and then taken to the Design tab for the maintenance plan. The Design tab consists of a properties section at the top of the screen and a plan designer surface that is empty for a new maintenance plan.
Existing maintenance plans are displayed in the Design tab when you right-click the plan and select Modify. Figure 33.13 shows the Design tab for a maintenance plan that was created with the Maintenance ...