June 2015
Intermediate to advanced
1800 pages
70h 6m
English
You can create or modify maintenance plans in SQL Server 2014 without using the Maintenance Plan Wizard. To create a new maintenance plan without the wizard, 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 30.15 shows the Design tab for a maintenance plan that was created with the Maintenance Plan ...
Read now
Unlock full access